Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell equal another cell
I have a statement that i update every month. There is a column that has the
current ending month. such as 10/31/08 this shows in each line in one column. i want to be able to change the first row to the next month such as 11/30/08 and have all the following cells in that column change at once. i can go to each cell and put the date cell in each one but is there a formula that i can use instead of having to to back and forth to the cell i change the date in? i can copy down but there are lines and underlines in the column and if i copy down the format will get copied also. i want each cell in this column to equal the one i change the date in. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
Fomula where one cell is equal to the other cell content & format | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel |