make a copy sheet of the 0506 spreadsheet using edit, move or copy sheet, and check create a copy. Then add your new columns from April 1st onto it.
make a copy sheet of the 0506 spreadsheet using edit, move or copy sheet, and check create a copy. Then add your new columns from April 1st onto it.
thats good, and thankyou for replying =] but it still doesnt update. what i want to accomplish is, when i enter data on the 05/06 in the months during 2006, it automatically updates on the 06/07 sheet, sorry if i havent been clear
i just tried to import the data on to a different sheet in the 06/07 workbook and then tried to do it from there, but it still doesnt work =[ here is a picture of what i mean (the highlighted area should have N/W all the way across but doesnt!)
\1
Last edited by koldtooth; 06-14-2006 at 09:57 AM.
hey not to worry =] i managed to accomplish it with a few complex Macros =] thanks for your help anyway!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks