parttime_guy
01-28-2013, 10:01 AM
Hi All,
Just need a macro
Sheet 1: has information in Column A (1:100) (different Names)
Sheet 2: has a form
Need to copy information from Sheet1 Cell A1 and paste in Sheet 2 (B2) same cell then print the form and loop till information is over in Column A of sheet 1.
I have the code of the print
Sub printing()
Sheets("Form").PrintOut
End Sub
But... :help I am stuck with the task of copy pasting the information in the same cell and then loop.
Please help.
Thank & Regards
Just need a macro
Sheet 1: has information in Column A (1:100) (different Names)
Sheet 2: has a form
Need to copy information from Sheet1 Cell A1 and paste in Sheet 2 (B2) same cell then print the form and loop till information is over in Column A of sheet 1.
I have the code of the print
Sub printing()
Sheets("Form").PrintOut
End Sub
But... :help I am stuck with the task of copy pasting the information in the same cell and then loop.
Please help.
Thank & Regards