Keeper4826
New Member
- Joined
- Nov 6, 2006
- Messages
- 47
I have a spreadsheet which tracks multiple Word reports (one row per report). Within each Word report are key pieces of information I need to have automatically imported into my spreadsheet. These pieces of information follow standard formatting rules and are preceded by a different code. Example:
Code1: Sentence
Code2: Date
Code3: Text
Code4: Date, City, Country (I only want the date on this one)
How can I automatically import the desired data to target cells, so I don’t have to manually copy the data one item at a time? What I'm envisioning is a single cell which links to the report (I've got this already). This would serve as a reference for formulas in the target cells. This way, formulas can be copied down the columns without worrying about hardcopying. Have four cells repeatedly access the same Word files seems very insufficient though. Either way, I don't know how to get started on this task.
Code1: Sentence
Code2: Date
Code3: Text
Code4: Date, City, Country (I only want the date on this one)
How can I automatically import the desired data to target cells, so I don’t have to manually copy the data one item at a time? What I'm envisioning is a single cell which links to the report (I've got this already). This would serve as a reference for formulas in the target cells. This way, formulas can be copied down the columns without worrying about hardcopying. Have four cells repeatedly access the same Word files seems very insufficient though. Either way, I don't know how to get started on this task.
