Hi All
I have attached a very basic example workbook -- normally there would be about 20 sheets all formated exactly the same but considerably more rows would be used. The "Input Text" sheet is what I use after receiving Emails in CSV an example on this sheet - click - Text To Columns - I then copy and paste the info into the correct row that matches the ID number and the column which holds the Code Number is it feasible to automate this proceedure with a Macro? an example on "Pack FC" sheet under the two header rows shows exactly what is required. Perhaps somebody could help or guide me in the right direction as I have no idea how to do this. Sometimes the Unique ID number is duplicated on other sheets in the workbook and on finding the number it would also fill the columns on this sheet with the same info.
Many Thanks
Sooty8