Hi guys...
I'm new to Macros so please bear with me...
I have 2 Spreadsheets (1 with a table of data, the 2nd has lookups to fields in the table & will be used to generate a print-out)
I require a macro to run through the 2nd sheet, and at each loop drop the cells referenced in the formulas by one cell (printing the page before starting the next loop).
So eg. =Sheet1!B1 must change to =Sheet1!B2 , print
then change to =Sheet1!B3 , print etc
I'm sure this is possible, but at this point far beyond me...
[Win XP / Excel 2003]
I'm new to Macros so please bear with me...
I have 2 Spreadsheets (1 with a table of data, the 2nd has lookups to fields in the table & will be used to generate a print-out)
I require a macro to run through the 2nd sheet, and at each loop drop the cells referenced in the formulas by one cell (printing the page before starting the next loop).
So eg. =Sheet1!B1 must change to =Sheet1!B2 , print
then change to =Sheet1!B3 , print etc
I'm sure this is possible, but at this point far beyond me...
[Win XP / Excel 2003]