LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default Is the solution in Exel? update data from Word

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding the solution to an Exel problem. MJohn Excel Worksheet Functions 3 September 1st 08 10:24 PM
Excel tables to Word--Best Solution? erik_gregory Excel Discussion (Misc queries) 3 March 6th 07 06:33 AM
Installation and Solution Update Question TCook Excel Programming 0 October 18th 06 04:35 PM
Data from Exel into Word Jere[_3_] Excel Programming 1 May 10th 04 06:16 PM
Replacing instances in word with data from exel Jere[_2_] Excel Programming 0 May 7th 04 12:31 PM


All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"