Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formulas but changing the column #
I have a tracking spreadsheet (Excel 2000) that I need to replace the
formulas each month with a new linking sheet. The only thing I need to change is the column number as the cell numbers stay the same. Currently, I link the first formula from the new sheet into the old sheet and then copy and paste the new column # to each cell. Is there an easier way to do this? Thanks, -- lynnydyns |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formulas but changing the column #
After reading your question several times, I am still not clear about the
set-up. Could you possibly give us an example? -- Gemini "lynnydyns" wrote: I have a tracking spreadsheet (Excel 2000) that I need to replace the formulas each month with a new linking sheet. The only thing I need to change is the column number as the cell numbers stay the same. Currently, I link the first formula from the new sheet into the old sheet and then copy and paste the new column # to each cell. Is there an easier way to do this? Thanks, -- lynnydyns |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying formulas but changing the column #
As an example .. on the summary sheet the formula would look like this
'Sum(Sheet1!B15+B78+B85)'. The sheet that we get the next month would have the same formula except the necessary data is in C column instead of B (Sheet2!C15+C78+C85). This is a fairly large sheet and it's time consuming to change all the formulas individually. I would appreciate finding an easier way to complete this task. Thanks, -- lynnydyns "Gemini" wrote: After reading your question several times, I am still not clear about the set-up. Could you possibly give us an example? -- Gemini "lynnydyns" wrote: I have a tracking spreadsheet (Excel 2000) that I need to replace the formulas each month with a new linking sheet. The only thing I need to change is the column number as the cell numbers stay the same. Currently, I link the first formula from the new sheet into the old sheet and then copy and paste the new column # to each cell. Is there an easier way to do this? Thanks, -- lynnydyns |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying a column of cells containing formulas without them changin | Excel Discussion (Misc queries) | |||
Copying formulas to end of Column | Excel Discussion (Misc queries) | |||
Copying Formulas From One Column To Another?? | Excel Worksheet Functions | |||
Copying forumla for vlook up but changing the column Index # | Excel Worksheet Functions | |||
Copying formulas without changing previous results/calculations | Excel Worksheet Functions |