|
|
Conditional cell color. by
geza
I have used conditional formatting before in order to change the shading of a cell based on the cell value. However, I would like to do the same except have...
|
July 2nd, 2004 02:39 AM
by geza
|
3 |
226 |
|
|
|
|
3 |
145 |
|
|
Last day of the Month??? by
ExcelDummie
I am creating a timesheet and i have inserted the first day of the month with a combo box to a linked cell A7 then in the rest of the column i add 1 to A7 then...
|
|
1 |
168 |
|
|
Excel external data import query by
Craig
I have a query that imports data from an Access database, this works fine but when I import the data the headings are imported too, how do I import the data...
|
|
1 |
439 |
|
|
If statements by
ExcelDummie
i cant get the OR bit right!!!
i want it to check whether Cell $a$40 or $B$40 matches $S$29 then H36-$K$2 if tru and "" if false
i can get it to do it for...
|
|
2 |
154 |
|
|
Number Format by
Alec Kolundzic
Can anyone help.
The following code is part of a number generator, that
fills a column with numbers in the format "0000" ie on 5
instances of AI, numbers 0700...
|
|
3 |
494 |
|
|
Reorganize excel listing by
Dean
I need to develop a product/order list from an existing list in a different format. I have attached both. Is there VBA code that can do this for...
|
July 2nd, 2004 03:31 PM
by Dean
|
2 |
236 |
|
|
|
|
4 |
291 |
|
|
|
|
2 |
347 |
|
|
convert formulas to values in place by
K. Georgiadis
I know how to convert formulas to values by copying to
another sheet with Paste Special. Is there a way to
change the formulas to values in place, without...
|
|
3 |
232 |
|
|
"Replace With" option by
Joey
Hi all
I would like to amend a column with phone numbers and change only the
first two characters to a "0"
Most of the numbers look like this;
44131 555...
|
|
2 |
156 |
|
|
Finding Value of a Cell in a Range by
Wendy L
In cell C1 I want to place a formula that will return a value of 1 if the
value of cell A1 is contained in the range of cells B1:B127 and a value of 0
is the...
|
|
6 |
408 |
|
|
Auto update of Pivot table by
K. Georgiadis
C. Pearson's website includes VBA code for automatically
updating a Pivot table upon opening the worksheet. Does
the code need to be inserted in "This...
|
July 2nd, 2004 05:21 PM
by jeff
|
1 |
413 |
|
|
Format/Row/Autofit by
Can someone please tell me why my text will not fit in
Autofit row. It just needs to be a little bit wider. It
never used to do this, is it because I'm now...
|
July 2nd, 2004 05:40 PM
by
|
4 |
636 |
|
|
switch 2 cells around by
whitedevil
Is there a way to switch two cells around? Copy something from cell A to
cell B and from B to A without using any extra empty cells. Maybe using
some...
|
|
2 |
202 |
|
|
Need to GOTO a calculated cell reference by
Dave Harker
I'm trying to create a household expenses/income sheet. I'm entering the day's income and expenditure figures and totalling them at the bottom of my worksheet....
|
July 2nd, 2004 06:10 PM
by jeff
|
1 |
357 |
|
|
What function would I use? by
Capn_Chord
I am making a spreadsheet for my work. In this
spreadsheet I enter data such as the name of a customer,
additional products they may have purchased, and...
|
July 2nd, 2004 06:15 PM
by CLR
|
3 |
146 |
|
|
|
|
5 |
242 |
|
|
How do I invert matrices? by
Aja
How can I make a matrix that looks like this
Jan Feb Mar
95 A B C
96 D E F
97 G H I
look like this
95 Jan A
95 Feb B
|
|
3 |
197 |
|
|
Pivot Table Max Columns - 2000/2002/2003 by
TimS
Dear All,
An annoying problem with pivot tables, when working with users with various versions of excel.
We use excel to allow end users to look at data via...
|
|
4 |
166 |