Hi everyone,
I am a newbie to Excel VBA. I need to accomplish an important automation task using Excel VBA. It requires pulling specific data/text from word file to excel sheet. Please see attached sample files.
The highlighted date and each date under it in word file needs to be extracted and put into the 'PO issue date' column in excel first sheet. Similarly, each part number (highlighted) in word file needs to be put it into the 'Funai Part No' column. Similarly, the quantity in word file under 'TOTAL' needs to be put into the 'Required Qty' column and PO number in word file (Lastrow end value - 70525003) needs to be put into the 'PO Number' column. This PO number will be similar for all other dates as well entered in excel.
I shall be grateful if any one can help as soon as possible. Thank you!
Reply With Quote
