I'm not really sure how to ask what I am trying to do. Maybe someone can point me in the right direction.
So this is what I want to do: My spreadsheet has about 2100 rows, in each row there are columns such as Location Number, city, state, address, telephone, general notes. I need to transfer the information from these cells for each row to go on a form (either a word document or similar) to basically make a one page sign off sheet for my workers to get signed in the field. So basically I would have 2100 different documents with the information from each row filled into each one.
You have a "template" and a "database" and you want to fill the "template" out with all the data from one row of the database, print it, then fill in the next row of data, etc. ?
_________________
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!)
'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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
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!)
Yes I have a database which is in rows. The data in the cells needs to go to fields on a template (word doc or similar). Each one would become a separate file preferably named by an id number. So what I am trying to do requires some programming? I don't have much experience in that area. What is the programming language? Any good tutorials out there to get me going?
VBA is the language used for the programming environment built into Excel. The link given above is to an Excel macro. There is a sample sheet attached to that page so you can see the concept in action.
VBA takes some learning, but it's not rocket science. You can do it if you commit some time.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
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!)
Reading this through I would think that you should set up the form for printing in an Excel sheet. Then populate that form from the database using VLOOKUP, you just need a unique id column for each line
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks