I think the VBA guys will be pretty happy with this one:
I have an Excel spreadsheet which has a load of data, starting with a single line address and then subsequent columns have a number in them. Theres 8 numbers (one for each day of the week plus a total). There are around 30 addresses in total.
I have set up a word file using mail merge and have extracted name and address information from an access database.
What I would like to do is this: based on the second line of the mail merged entry - which is a single line address, is to match it with that in the excel spreadsheet. If they match, then to drag back not only the address (say in column A), but to drag back the remaining 8 columns x 1 row with the numbers in them, specific to the address.
Of course I would like to do this 30 times.
Any ideas??
I have an Excel spreadsheet which has a load of data, starting with a single line address and then subsequent columns have a number in them. Theres 8 numbers (one for each day of the week plus a total). There are around 30 addresses in total.
I have set up a word file using mail merge and have extracted name and address information from an access database.
What I would like to do is this: based on the second line of the mail merged entry - which is a single line address, is to match it with that in the excel spreadsheet. If they match, then to drag back not only the address (say in column A), but to drag back the remaining 8 columns x 1 row with the numbers in them, specific to the address.
Of course I would like to do this 30 times.
Any ideas??
