Word forms update Excel

  • Thread starter Thread starter JudithJubilee
  • Start date Start date
J

JudithJubilee

Hello there,

I work for a solicitors that has a number of branches.
Each month I need to collate data from the various
branches.

The data I collect consists of:
Number of Issues
Number of Issues dealt with on time
No. of Break and Enter issues
No. of Vandalism issues
No. of Muggins
No. of Shoplifters, etc.

At the moment each month the various branches open up a
Word doc that has explanations of each of the numbers and
places for the branch to add their own figures. They then
email me the docs. I then have to physically type these
figures into the relevant cells in an Excel spreadsheet.

I would like a way of updating the spreadsheet from the
Word docs. I know how to add fields and lock the docs but
how do I get the data from the Word fields into Excel
cells??

Any help would be greatly appreciated.

Thanks in advance

Judith
 
G'day "JudithJubilee" <[email protected]>,

You would need to write quite a bit of VBA. If required, there are
several of us who could assist you commercially with this if required.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


JudithJubilee reckoned:
 
Back
Top