Need To Support for Loop Printing Form
I need to update Sheet 1 each rows data (A1;B1;C1;D1/ A2;B2;C2;D2; ...) in to the Invoice Format(Sheet2) and Print every sheet..
IF I CAN STOP THIS PROCESS AFTER PROCESSING GIVEN NUMBER OF ROWS AND THEN STOPS ITS GOOD!!
I have Work book Contains whic has two sheets
Sheet 1:
Theres Table with 4 columns
Column 1 [A]: Name
Column 2 [B]: Amount
Column 3 [C]: Payment Type
Column 4 [D]: Purchase Order No
Sheet 2:
Theres some Invoice Format:
I need to update Sheet 1 each rows data (A1;B1;C1;D1/ A2;B2;C2;D2; ...) in to the Invoice Format and Print every sheet..
IF I CAN STOP THIS PROCESS AFTER PROCESSING GIVEN ROWS AND THEN STOPS ITS GOOD!!
Ex:
Name In to Sheet 2 [B2]
Amount In to Sheet 2 [D5]
Payment Type In to Sheet 2 [D3]
Purchase Order No In to Sheet 2 [C1]
Can Anyone Help with this????? Is this possible with Excel????
'FILL OUT A TEMPLATE FROM A DATABASE
I have a macro for taking the data from a database sheet and filling out a template sheet over and over again with the data.The macro fills out the template and saves each one as a separate file OR creates a separate sheet, your choice. That last part can be tweaked to do other things, this is mainly to demonstrate a simple way to fill out a form from a row-based database.
You could change the SAVE portion of the code to simply print sheet2, your template, for instance.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks