Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Background:
I have a 60 page Word document that is updated weekly for staff/project meetings. Any and all changes are made and previous information is strike through font for historical purposes. Example multiple columns of multiple criteria for multiple locations. All criteria is labled the same for each location: COLUMN 1 of Word Table COLUMN 2 (bullet) Comment Revisions 5day [12/11/06 to 01/26/07 (strike through)] New text 05/25/07 to 05/30/07 From that 60 page 'living' word document, an excel sheet is updated mannually: Col1 A/B Concept (info from .doc table) Col2 Location Name (info from .doc table) Col3 Comment Revisions (info from .doc table) I know we can create links to each item; what I'd like to do is develope a macro that searches for the matching header in Word and returns the value in the specific Excel cell. I may not be explaining this clearly, I apologize. To me it's complicated therefore hard to explain. Your advice is warmly received. -- Thank you, scrowley(AT)littleonline.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding the solution to an Exel problem. | Excel Worksheet Functions | |||
Excel tables to Word--Best Solution? | Excel Discussion (Misc queries) | |||
Installation and Solution Update Question | Excel Programming | |||
Data from Exel into Word | Excel Programming | |||
Replacing instances in word with data from exel | Excel Programming |