markyc
05-10-2006, 06:39 AM
I have two sheets
Sheet 1 has a list of risk numbers in column A, this list can be upto 2000 records long
Sheet 2 is a report that needs to contain the risk number at the top of the report.
I have created a macro that copies first risk number, pastes into top of report, prints report, goes back to sheet 1 and selects next risk number.
I want to be able to tell macro only to do this loop 10 times, to ease data sent to network printer
Please can you advise
Sheet 1 has a list of risk numbers in column A, this list can be upto 2000 records long
Sheet 2 is a report that needs to contain the risk number at the top of the report.
I have created a macro that copies first risk number, pastes into top of report, prints report, goes back to sheet 1 and selects next risk number.
I want to be able to tell macro only to do this loop 10 times, to ease data sent to network printer
Please can you advise