| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying a reference
I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec
worksheets are set up identical but after each month, different data is entered for that month. The Total worksheet has 12 columns titled Jan - Dec. Total!A1 = Jan!$A$1. Is there a way to copy the reference in Total!A1 to Total!A2 so that Total!A2 = Feb!A$1$, Total!A3 = Mar!$A$3, etc... ???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying a reference
Check out the 'Indirect' function.
HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "jrw" wrote: I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec worksheets are set up identical but after each month, different data is entered for that month. The Total worksheet has 12 columns titled Jan - Dec. Total!A1 = Jan!$A$1. Is there a way to copy the reference in Total!A1 to Total!A2 so that Total!A2 = Feb!A$1$, Total!A3 = Mar!$A$3, etc... ???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
| Copying a Formula To Reference Multiple Worksheets | Excel Worksheet Functions | |||
| Excel: hold a reference to a single cell when copying formulas? | Excel Worksheet Functions | |||
| Copying a mixed reference formula | Excel Discussion (Misc queries) | |||
| copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
Linear Mode
