Every day, we extract data for metres printed through our machines. Every job that runs has its own file with all of the machine data presented in a list (Field name then data) in column A. I want a macro that allows me to open the workbook for any job and it copies the relevant data into a row. However, the problem is it always references the file that I record the Macro in (Even when I select Record to Personal) And i get Runtime Error 9 when I run in a new workbook.
Macro is below and I will highlight the first row it highlight for debug.
So obviously the issue is "csm cadbury 7fj bites,430" only exists for the original sheet and is a new job name for each one. any help appreciated if you want anymore info please let me know.
Snippet.PNG
Bookmarks