View Single Post
 
Old 06-24-2014, 07:40 PM
smn smn is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 4
smn is on a distinguished road
Default Retrieve page numbers in Word doc from set of variables in Excel file

Hi, I have an Excel spreadsheet which has 1 column of variables (i.e., 100+ customer names). I also have a 400 page Word document with each page containing a customer's name. There are numerous instances of each customer in the Word document but the pages are not sorted (e.g., Joe Smith occurs on pages 2,5,18,49; Mary Smith occurs on pages 3,7,31,55,etc). I'm trying to retrieve the page numbers for each respective customer, that way when I print the statements, they will be in order by customer name. I had tried to merge several VBA scripts I found online but to no avail. I would be very appreciative if someone could offer some guidance. Thank you all in advance.
Reply With Quote