If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|