Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating a cell reference
I have a worksheet that gets data from a worksheet in another file. Each
month the cell references have to change to the next row. For example, this month I'm referencing C134, which is the June line on the other file. Next month, I need to reference C135, the July line. How can I automate this? My first thought is to use a macro, but I can't find an example anywhere of a VBA macro that moves a cell reference to the next row. Any suggestions would be appreciated. Thank you, Paula |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Reference updating | Charts and Charting in Excel | |||
Updating a reference ROW | Excel Discussion (Misc queries) | |||
Updating Indirect Reference(s) | Excel Worksheet Functions | |||
Updating cells which reference a defined name | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions |