I have set up an excel spreadsheet. I have then created a form (i need people to physically sign off the content of each row) on another sheet which I have used lookup based on an item code. What I want to do to get a macro or something to sequentially go down the spreadsheet and change the items code to that it prints out an individual form for each row.
Anyone got any ideas.
Thank you
Why don't you use MS Word Mail Merge to "Letters" using your Excel spreadsheet as the source document.
I would think that's much easier than developing and maintaining VBA code.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I've posted code to do this in the past, you need to attach a dummy workbook.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for this will create a dummy workbook if that is OK and send it over
Thanks DWB
Thanks for this may need to revert to this but would prefer to use VBA
Re: Printing individual forms from a table
Test Log1.xls
Please find attachment I hope it make sense
DWB
Try this
Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button
Alternatively add a button to the form
Thank you so much!! Works perfectly
Really appreciate it
DWB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks