I need help to write the macro. I've started with a very basic script, but need help to fill in the details. Let me know if this is too much, I can break the steps into several requests. (sample files attached)
From the Accounts file, I need to open DataFile1.xlsx and select each worksheet, read the final number in column Y, then copy that corresponding number back to the Accounts file. If the worksheet name in the DataFile1 is not listed in Accounts, then a row needs to be inserted in Accounts with that worksheet name.
'from the highlighted column, select the pathname and filename in rows 7 & 8, open the file
'read the worksheet names,
'If not found in Accounts, then insert row() with worksheet name. EndIf
'Find last number in column Y, copy to Accounts of corresponding row