I have 144 workbooks all of the same format (orders sent in by customers). Each has all the same data in the same columns but are of different lengths depending on the number of lines on the order.
I need to open each one in turn and add the name of the file to the next Column (M), then close and save the file and repeat on all 144 files. (NB there will be no blank rows but there are a couple of blank columns)
Sample data of 3 rows
5279427 Biz Mr Fred Fox ABC Co 22 St John Street Dudley Road Brierley Hill London DY51LQ
5268422 Biz Mr D Jones My Co 123 the lane Bartholomew Wy Horsham Manchester RH12 5HJ
5275808 BIz Mr Lee Smith Smith Partners 5 the Road Pembroke Coventry SA71 5PZ
Any ideas. I can get a sheet with all the filenames etc and everything is saved in one place and I can save over the original files
Thanks
Rob
I need to open each one in turn and add the name of the file to the next Column (M), then close and save the file and repeat on all 144 files. (NB there will be no blank rows but there are a couple of blank columns)
Sample data of 3 rows
5279427 Biz Mr Fred Fox ABC Co 22 St John Street Dudley Road Brierley Hill London DY51LQ
5268422 Biz Mr D Jones My Co 123 the lane Bartholomew Wy Horsham Manchester RH12 5HJ
5275808 BIz Mr Lee Smith Smith Partners 5 the Road Pembroke Coventry SA71 5PZ
Any ideas. I can get a sheet with all the filenames etc and everything is saved in one place and I can save over the original files
Thanks
Rob