Importing word doc data into excel

[55giants5]

Hello, Happy Friday!

I'm trying to figure out a way to expedite my current workflow. I have a report that's generated into a word document. I manually input select pieces of data from this document into an excel template so that I can present to clients.

The word document looks something like this:

the information for 123 state street may be on Excel sheet 1, 123 park lane may be on sheet 3. However I may only need the color (Column B) or the price (Column A). The location on the excel spreadsheet is fixed so there's no change from each report/excel template.

I'm wondering if there's a way to get this data into an excel template, without having to manually input it. Whether it be an excel function i'm overlooking or having to create a macro for it.

I'm thinking I'd need to create a macro that searches the word document for "123 state street", if found -- it inputs "red" or "$1000" into the set location on the excel sheet. Would this even be possible?

Thanks in advance for your input!

 

[55giants5]

Any ideas would be appreciated

 

[Macropod]

Is this process to be driven from Word, or from Excel? That makes a huge difference in the way it is coded.
What happens when an address in Word isn't found in Excel? Or vice-versa?
Is it always the same document/workbook you're working with, or does the user need to be able to choose either/both?

PS: Your premature bumping of the thread (see http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html #12) diminished the chance of getting an early response as doing so removed it from the 0-replies search many users here employ to find unanswered threads...

 

[55giants5]

I should have read the forum rules! Thanks for alerting me of it.

The process is to be driven from excel. Good question about the addresses not being found, but wouldn't there be a way to just ignore if not found?

The workbook would always be the same, but the information in the word document may vary.

 

[Macropod]

The workbook would always be the same, but the information in the word document may vary.

But that doesn't tell me whether it's always the same document or if the user should have to choose one (or more) documents each time.