parttime_guy
05-14-2008, 07:53 PM
Hi,
I have 2 worksheets
Sheet1: Data (all information in rows) maybe 15 colums
Row 1 of Sheet1 consists of a header giving the description of the column
Row 2 of Sheet1 consist the data that has to be linked into Sheet2: The Form that has to printed
Row 3 of Sheet1 till the end consist of final data
Sheet2: The Form that has to be printed
This has links to Row 2 of Sheet1 and the data is displayed on various parts of the Form
Problem
Please help with a macro:
Information on Row 3 of Sheet1 should be copied and pasted in Row 2 of Sheet1 and the Form should be printed (the Macro should continue to print all rows available till the end).
Thx-n-BR
: pray2:
I have 2 worksheets
Sheet1: Data (all information in rows) maybe 15 colums
Row 1 of Sheet1 consists of a header giving the description of the column
Row 2 of Sheet1 consist the data that has to be linked into Sheet2: The Form that has to printed
Row 3 of Sheet1 till the end consist of final data
Sheet2: The Form that has to be printed
This has links to Row 2 of Sheet1 and the data is displayed on various parts of the Form
Problem
Please help with a macro:
Information on Row 3 of Sheet1 should be copied and pasted in Row 2 of Sheet1 and the Form should be printed (the Macro should continue to print all rows available till the end).
Thx-n-BR
: pray2: