Generate_Invoice.xlsmHi Paul, This is Mayur (continuing from stackoverflow) as there is no option to attach files. Hope you are same macropod [IMG]file:///C:/Users/User/AppData/Local/Temp/msohtmlclip1/01/clip_image001.gif[/IMG]
Attached here with are the two invoice files... I am trying to copy the tables (with only header row: with keyword "Description").
Following is the code that i am using. Also wanted to copy Invoice / sales order number with Date and paste in column E.
The instr function is unable to find "Description". Hope you have all the details now. Sorry for the confusion and taking so much time of yours.