Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
I have a spreadsheet with about 500 rows on it and it calculates in different
fields down the line. It has the 12 monthly columns at the top and every month I go in and delete out the one on the left side and add the new column at the right and then I have to redo all of the formulas - is there a way I can do this without having to key in the formulas again. Thanks! -- Miss Karen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
Karen,
When you say 're-key' the formulas, are you copying the formulas over from column to the next or are you using another method for moving those formulas. Is there anything stopping you from just copying the formulas over one column? Can you give an idea of what the formulas do? Are they lookups, sums, averages, etc.. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Miss Karen" wrote: I have a spreadsheet with about 500 rows on it and it calculates in different fields down the line. It has the 12 monthly columns at the top and every month I go in and delete out the one on the left side and add the new column at the right and then I have to redo all of the formulas - is there a way I can do this without having to key in the formulas again. Thanks! -- Miss Karen |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
PJ,
I usually copy them over but some of them when I delete the column on the left it shows and message of #ref and I have to rekey in the entire formula. It has been alot of work and I was thinking that there has to be an easier way to accomplish this spreadsheet. The formulas do averages, sums and some of the fields have calculations in them and that calculation is used in another field calculation. Any help would be greatly appreciated. Thanks -- Miss Karen "PJFry" wrote: Karen, When you say 're-key' the formulas, are you copying the formulas over from column to the next or are you using another method for moving those formulas. Is there anything stopping you from just copying the formulas over one column? Can you give an idea of what the formulas do? Are they lookups, sums, averages, etc.. -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "Miss Karen" wrote: I have a spreadsheet with about 500 rows on it and it calculates in different fields down the line. It has the 12 monthly columns at the top and every month I go in and delete out the one on the left side and add the new column at the right and then I have to redo all of the formulas - is there a way I can do this without having to key in the formulas again. Thanks! -- Miss Karen |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
I have a spreadsheet with about 500 rows on it and it calculates in
different fields down the line. It has the 12 monthly columns at the top and every month I go in and delete out the one on the left side and add the new column at the right and then I have to redo all of the formulas - is there a way I can do this without having to key in the formulas again. Thanks! This may or may not work, depending on the formulas. Instead of deleting column 1, copy columns 2-12 and paste onto columns 1-11. Then update the constant values in column 12. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
This didn't work I got the same thing #ref.
Let me know if you can think of something else. Thanks! -- Miss Karen "MyVeryOwnSelf" wrote: I have a spreadsheet with about 500 rows on it and it calculates in different fields down the line. It has the 12 monthly columns at the top and every month I go in and delete out the one on the left side and add the new column at the right and then I have to redo all of the formulas - is there a way I can do this without having to key in the formulas again. Thanks! This may or may not work, depending on the formulas. Instead of deleting column 1, copy columns 2-12 and paste onto columns 1-11. Then update the constant values in column 12. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
Instead of deleting column 1, copy columns 2-12 and paste onto
columns 1-11. This didn't work I got the same thing #ref. Let me know if you can think of something else. Instead of deleting column 1, maybe hiding it would meet the need. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling 12 Spreadsheet
It doesn't show up in row one or twelve those are fine it is in the formulas
that are further down the page. -- Miss Karen "MyVeryOwnSelf" wrote: Instead of deleting column 1, copy columns 2-12 and paste onto columns 1-11. This didn't work I got the same thing #ref. Let me know if you can think of something else. Instead of deleting column 1, maybe hiding it would meet the need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling sum | Excel Discussion (Misc queries) | |||
How can I setup a rolling 13 week spreadsheet? | Excel Worksheet Functions | |||
rolling | Excel Worksheet Functions | |||
Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions | |||
rolling months | Excel Discussion (Misc queries) |