Linking, templates or other - Project Due By 4-11-02

tjboon · Apr 9th, 2002, 02:01 PM

I have an Excel Workbook that I will need to use in some form of a template as I need to enter info on a monthly basis only pertaining to that month (sometimes info spills over from one month to the next so it is not strictly date specific). The information that is entered into the Excel Workbook then needs to be linked to a Word document also on a monthly basis. It is my understanding that I should not link an Excel template as the source to a Word document.

In the near future, I will need to collect all the information from the monthly reports and make requested trend reports. Could be 3 months to several years. Could be limited info or all info from both the Excel report and the Word report.

Please assist me on as to the best method I should do this.

Al Chara · Apr 9th, 2002, 02:45 PM

Why do you need to link it to Word? I bet excel can handle what you want to do in Word.

tjboon · Apr 9th, 2002, 02:54 PM

Because that is where the big boss wanted part of the report. Even though I did try to push keep all of it in excel.

Al Chara · Apr 9th, 2002, 03:39 PM

Dreamboat,

What do you think about this?

Apr 9th, 2002, 02:45 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Why do you need to link it to Word? I bet excel can handle what you want to do in Word. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 02:01 PM	#1
tjboon New Member Join Date: Apr 2002 Posts: 2	I have an Excel Workbook that I will need to use in some form of a template as I need to enter info on a monthly basis only pertaining to that month (sometimes info spills over from one month to the next so it is not strictly date specific). The information that is entered into the Excel Workbook then needs to be linked to a Word document also on a monthly basis. It is my understanding that I should not link an Excel template as the source to a Word document. In the near future, I will need to collect all the information from the monthly reports and make requested trend reports. Could be 3 months to several years. Could be limited info or all info from both the Excel report and the Word report. Please assist me on as to the best method I should do this.

Apr 9th, 2002, 02:54 PM	#3
tjboon New Member Join Date: Apr 2002 Posts: 2	Because that is where the big boss wanted part of the report. Even though I did try to push keep all of it in excel.

Apr 9th, 2002, 03:39 PM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Dreamboat, What do you think about this?