Hi all,
I need to split my worksheet into multiple workbooks based on column B and name the new workbook according to column B. For exampleCapture.JPG
and save as SM-30403-0.xlsx and so on.
I know there are many such examples around but my attempt to adapt from the examples gave me errors "runtime error 1004 - the file could not be accessed" trying to write the new workbooks. I would appreciate any help and advice as I am going round in circles getting nowhere.
Bookmarks