Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VB Scripting/Macro - Filling/Editing Worksheet References
Question:
What VB code will allow me to rewrite just the worksheet reference in a function/cell reference. For example it says =January!$AH40 and I would like a macro that would change it to =February!$AH40 Any suggestions would be greatly appreciated!!! :) Background: I have 12 cells in a row that each refer to the same cell location on twelve different worksheets within the same workbook. The fill function does not "fill" the worksheet reference. It is too time consuming to manually input or edit 2016 cells. |
#2
|
|||
|
|||
Hi
you may have a look at the INDIRECT function for this -- Regards Frank Kabel Frankfurt, Germany "Meghan" schrieb im Newsbeitrag ... Question: What VB code will allow me to rewrite just the worksheet reference in a function/cell reference. For example it says =January!$AH40 and I would like a macro that would change it to =February!$AH40 Any suggestions would be greatly appreciated!!! :) Background: I have 12 cells in a row that each refer to the same cell location on twelve different worksheets within the same workbook. The fill function does not "fill" the worksheet reference. It is too time consuming to manually input or edit 2016 cells. |
#3
|
|||
|
|||
This will change the sheet name when copied down
=INDIRECT("'"&INDEX({"January";"February";"March"; "April";"May";"June";"July";"August";"September";" October";"November";"December"},ROW(1:1))&"'!AH40" ) assuming the 12 sheets are named after the months Regards, Peo Sjoblom "Meghan" wrote: Question: What VB code will allow me to rewrite just the worksheet reference in a function/cell reference. For example it says =January!$AH40 and I would like a macro that would change it to =February!$AH40 Any suggestions would be greatly appreciated!!! :) Background: I have 12 cells in a row that each refer to the same cell location on twelve different worksheets within the same workbook. The fill function does not "fill" the worksheet reference. It is too time consuming to manually input or edit 2016 cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |