If there is another program that can perform this task better I could probably switch.
quote:
Bajah was listening to Cher while typing:
I'm not sure there is a way to do that, though advanced macros might make it possible. It'd be over my head, that's for sure.
I'm trying to automate a very tedious task at work. I'm covering a job I don't normally do and I can't believe someone would spend like two hours a day hand-writing copying data from a printed sheet to a sheet with set entry locations.
I'm sure it can be done somehow, but it's over my head as well.
Or you could try to do a mail merge from Excel into Word. If you can't mail merge directly from Excel into Word, then import from Excel to Access and mail merge into Word from there. `Doc fucked around with this message on 08-08-2006 at 04:13 PM.
quote:
`Doc said this about your mom:
You could create a new sheet, modify the cell sizes & text positions, and put dynamic links from the new sheet to the data on your old sheet. Use print preview to show you where the pages start/end. It would be a lot of work, but you'd only need to do it once.Or you could try to do a mail merge from Excel into Word. If you can't mail merge directly from Excel into Word, then import from Excel to Access and mail merge into Word from there.
I'll have to try these at work tomorrow. The idea of automating this process is really attractive to me.
Thanks for the suggestions.
quote:
`Doc probably says this to all the girls:
You could create a new sheet, modify the cell sizes & text positions, and put dynamic links from the new sheet to the data on your old sheet. Use print preview to show you where the pages start/end. It would be a lot of work, but you'd only need to do it once.
I'm pretty certain this method will work fine, but I don't know how to set up the dynamic links.
quote:
Inferno-Spirit had this to say about the Spice Girls:
I'm pretty certain this method will work fine, but I don't know how to set up the dynamic links.
That's the ugly way to do it. You really want to use a Word mail merge. That way you can use page breaks, position the words at the right places, and do it right. Playing around with column and row sizes in excel, trying to make it all the right sizes is inelegant and will have problems.
It's also a pain in the ass compared to doing it the right way.
No, Really. Bite me.
quote:
Burger had this to say about (_|_):
You really want to use a Word mail merge.
I don't know how to do this.
You just have to set up the excel file in the right manner, and then create a mail merge template in Word. Your best bet is for every "fill in the blank" on the sheet you're printing on, go "insert-> text field" in word, and then inside the new text box, put the appropriate field from the mail merge. Then, resize and drag it to the proper location on the page.
Print one out, move the boxes. Rinse and repeat until they're in the right places.
No, Really. Bite me.
quote:
Burger stopped beating up furries long enough to write:
Following the first two tutorials on this page: http://www.mistupid.com/technical/mailmerge/index.htmYou just have to set up the excel file in the right manner, and then create a mail merge template in Word. Your best bet is for every "fill in the blank" on the sheet you're printing on, go "insert-> text field" in word, and then inside the new text box, put the appropriate field from the mail merge. Then, resize and drag it to the proper location on the page.
Print one out, move the boxes. Rinse and repeat until they're in the right places.
This worked perfectly, thanks.
