G
Guest
I am trying to copy tables with data from a Word document into an excel
database. Both the Word table and the Excel database have labels (in excel
they are located down column A). I want the corresponding data to copy from
the word document into the Excel spreadsheet. The problem is that someone
else created the labels in the Word Table, so not all labels are present and
some labels are incorrect (so they are not in my Excel spreadsheet). This
makes it impossible for me to use LOOKUP. Is there any other way to make
sure that corresponding data gets put into the correct field?
Here's a short sample of both:
(This is the first 3 entries in the Word table)
AAH 2
ABE 9
ABI 2
ABQ 11
(These are my first 4 labels in Excel)
ABE
ABI
ABQ
ABR
database. Both the Word table and the Excel database have labels (in excel
they are located down column A). I want the corresponding data to copy from
the word document into the Excel spreadsheet. The problem is that someone
else created the labels in the Word Table, so not all labels are present and
some labels are incorrect (so they are not in my Excel spreadsheet). This
makes it impossible for me to use LOOKUP. Is there any other way to make
sure that corresponding data gets put into the correct field?
Here's a short sample of both:
(This is the first 3 entries in the Word table)
AAH 2
ABE 9
ABI 2
ABQ 11
(These are my first 4 labels in Excel)
ABE
ABI
ABQ
ABR