Making a Macro to create a report in word

Hi, I have a multi-tabbed excel sheet that i would like to pull a report from the workbook is a work log for my technicians and i need to be able to range it by a start and end date. And if possable I would like it broke into to the set titles for the report sections I have 4 fields. all the sheets are formatted the same.

Thanks
Dennis

Hi Dennis and welcome to he board
Can you show us how far you already got ?
Can you post a sample of your data and an example of what you want?

One easy method is to use FormFields. Here is an example.

Please Login or Register  to view this content.

I tried a few scripts and none of them pull from all tabs. The data I need is in column "B" the report is pulled by the date range in "A" and it would pull the hole row for the records that match.

Dennis

You have not provided enough details to know what you are doing.

Are you making a one record document or will it be like a mailmerge where multiple records create a many page document?

In any case, I don't know how to help if I don't know your rules.

Thanks,
I have 17 technicians that work in my shop repairing the installing equipment on a daily basis. currently we keep a lillte xls sheet and update it and send it to our boss every Thursday everyone had a different format and layout. So compiling a report took about 2-3 hours. So I set up a xls workbook with a set format with tabs for each tech. What I am trying to do now is to pull an report from the xls workbook. The report would pull info from the workbook for a set date range and pull the info into a word or text document. I would like to be able to layout the report into subsections per the work type being preformed ie a PMI, Training, Internal project, External project, or a ticket.

Create your MSWord DOT file with the Text Form Fields from the Forms toolbar. Double click each to set the bookmark name. This is the FormFields name.

If you can create a short example xls and dot file, and point out or fill the dot file to make a doc file, it will be easier to help you. Make these as simple as possible. You can add the bells and whistles when you get the basics down.

Here are the xls and doc files that I used. Put the doc file in the same folder as the xls.