Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to copy data from one work sheet (A) to another (B); instead of using
a normal relative cell reference (i.e., copy A1 to A1, A2 to A2, etc), I want each row in worksheet A to be copied to every 31st row in worksheet A: A2 in worksheet A should be copied to A2 in worksheet B A3 in worksheet A should be copied to A32 in worksheet B A4 in worksheet A should be copied to A63 in worksheet B .. etc Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relative cell reference | Excel Discussion (Misc queries) | |||
Changing Cells from Relative to Absolute Reference | Excel Discussion (Misc queries) | |||
Relative Cell Reference | Excel Worksheet Functions | |||
changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) |