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. |
cell equal another cell
Say we are looking to fill column Z.
In Z1, enter: =DATE(YEAR(Y1),MONTH(Y1)+1,DAY(Y1)) this gets the new date from the old column. In Z2, enter: =Z1 and copy down the column This propagates the new date down the column -- Gary''s Student - gsnu200814 "JoAnn1877" wrote: 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. |
cell equal another cell
Try this in a copy of your file first...
Suppose your dates are in Col A Enter the new date in A1 Select Col A Choose Edit|Replace In Find What enter the new date In Replace With enter =$A$1 Click on Replace ALL "JoAnn1877" wrote: 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. |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com