Hi All ,
There is no ws/wb protection in the spreadsheets.
I attached 2 sample xls. Over all it's 4 files including before/after. The range starts from Row13 in all ws in Sample1. The range slightly changes in Sample2 - it's Row10 in some tabs. Apart from blank rows and blank columns I also need to remove the entire row where it says NE, NW, YH, EM, WM, E, L, IL, OL, SE, SW. At the end of the range there is a row which gives source info and bullets/numbering for some notes. I need to keep them as it is.
I only need to delete blank rows and blank columns and some certain rows in the range. Because first row of the range might change that's why I've thought mesage box would be an effective solution in this case. However you guys are expert so know much much better than I do, you might suggest other options?
PS: Sample2 has got some hidden worksheets which shouldn't be included to the process. Also some tabs in Sample2 has got data validation drop down lists which should remain as it is. ( I don't know if this would cause any issues). There are many spreadsheets in this format that's why I want to create one folder and to be able to run the script for all of them.
Cheers
B.
Reply With Quote