copying (an anchored col) and pasting to incremental colum
Posted by keith kemble on February 03, 2002 10:03 AM
At present I run an archiving macro that selects an anchored column on one sheet and pastes the data to another sheet.
Each week I have to replace the cell reference in the paste section of the macro, manually, so that each week the data moves right one column.
I have linked cell contents up using lookups but cannot get round manually find and replace the macro contents.
I require the past fuction to reference the contents of a cell dynamically when you enter a week number.