Hi everyone,
Hope all is well. A quick and sincere thank you, for all the assistance I have received from this Forum.
I am asking for assistance once more, could someone please assist me with a project I am working on?
I need to clear the contents of the cell in Row "A", if the cell in Row "I" is blank.
The issue, is there are roughly 1200 excel documents in a folder and subfolders. That is a painful amount of opening workbooks, sort ascending and deleting. Not on my top 10 list of things to do.
If someone could create a code to do this, and loop it through a folder (I can move all the files to a single folder manually, not an issue), I would be greatly appreciative.
I can provide a mock sample if required.
Thanks in advance.
Bookmarks