[jcarter]

Hi Ya'll-
Just found OA because I had a very bad day and set back yesterday. Long story. But, I rarely give up. I am trying, on my own, to redesign some projects that I must do on a weekly basis.

I need to get info from an Excel worksheet to another document (word), very simple format. The worksheet is a weeks worth of catering requests. I need to create an instructin sheet for each event by pulling info from about 6 rows/columns, but creating approx 50-60 different sheets (each has date, delivery time, event time, event name, event contact, order)

Does this make sense? I have tried and tried to find how to do this. Any ideas? Suggestions? Otherwise I have to retype each event on to a word doc, take about 2-3 hours each week. There has to be a better way.

Thanks. jc

[NicoleMiller]

Hi jc,

The only thing I can think of off the top of my head would be to highlight all the cells of the excel document that you want to transfer to Word and copy them. After you have them copied you can open a new word document and select "Paste Special" and select "Formatted Text" from the options. This should pasted your columns and rows into the Word document and keep the cell formatting.

Also, check out the article "Inserting Excel Data in a Word Document", it has some good pointers.

I hope this helps.

Nicole

[SheRex]

Have you tried creating your generic word document and inserting merge fields based on your excel worksheet? It might take a while to get the set up just right but afterwards it should only take a few minutes to do the whole thing.

[Jodith]

Yes, I've often used excel spreadsheets as the data for a mail merge document. In some versions of Word, though, you have to have a converter for it to work.

[ttom2tone]

Trying to msck an excel time sheet that lets me track time and what they are doing like time I clock in and what job I am going to and what time I completed it in

[Libby Huffman]

Hi ttom2tone,

You've come to the right place. We have an extensive Templates and Documents section that includes a daily time sheet. However, if you're looking to account for your activities by the hour, check out our activity log.

Hope this helps.

[Jodith]

If you look here, you'll find a post I did on keeping a time log. I've got a link there to the one that I used to track my time. It uses a pivot table to total time by category of job.

[relampico]

Originally Posted by jcarter

Hi Ya'll-
Just found OA because I had a very bad day and set back yesterday. Long story. But, I rarely give up. I am trying, on my own, to redesign some projects that I must do on a weekly basis.

I need to get info from an Excel worksheet to another document (word), very simple format. The worksheet is a weeks worth of catering requests. I need to create an instructin sheet for each event by pulling info from about 6 rows/columns, but creating approx 50-60 different sheets (each has date, delivery time, event time, event name, event contact, order)

Does this make sense? I have tried and tried to find how to do this. Any ideas? Suggestions? Otherwise I have to retype each event on to a word doc, take about 2-3 hours each week. There has to be a better way.

Thanks. jc

Obviously you found a solution to your problem by now. What was it?

[jctlcdc]

Originally Posted by NicoleMiller

Hi jc,

The only thing I can think of off the top of my head would be to highlight all the cells of the excel document that you want to transfer to Word and copy them. After you have them copied you can open a new word document and select "Paste Special" and select "Formatted Text" from the options. This should pasted your columns and rows into the Word document and keep the cell formatting.

Also, check out the article "Inserting Excel Data in a Word Document", it has some good pointers.

I hope this helps.

Nicole

I am an alcohol and drug counselor working primarily with criminal justice clients so naturally, I have a lot of reports that I have to send to courts and probation officers.
I use MS Word 2003 mail merge for my reports. First I set up an excel sheet with all the pertinent data in columns, ie, Name, DOB, PO, Admitted, Discharge date, etc.

Then I open Word -> Tools -> Letters and mailings -> and write the document. At this point you can use the wizard or set up the document manally inserting the fields you want to use in the document.

It seems a little complicated at first bit is actually fairly simple once you play around with for awhile. I could email you an example of the way I do it if you would like.

johnny@sos-tx.com

[tlangley]

Originally Posted by jcarter

Hi Ya'll-
Just found OA because I had a very bad day and set back yesterday. Long story. But, I rarely give up. I am trying, on my own, to redesign some projects that I must do on a weekly basis.

I need to get info from an Excel worksheet to another document (word), very simple format. The worksheet is a weeks worth of catering requests. I need to create an instructin sheet for each event by pulling info from about 6 rows/columns, but creating approx 50-60 different sheets (each has date, delivery time, event time, event name, event contact, order)

Does this make sense? I have tried and tried to find how to do this. Any ideas? Suggestions? Otherwise I have to retype each event on to a word doc, take about 2-3 hours each week. There has to be a better way.

Thanks. jc

Hi JC, not sure if you still need assistance with Excel, but you can always email me or IM me. I know alot about "pulling data" from excel worksheets, so I'm willing to give it a shot at solving your issue. You can reach me at tracy.langley@ildmail.com or AOLIM at tracyatild@aol.com or MSNIM at tracy.langley@ildmail.com.

Tracy