Hi All,
I need some help with some excel files that I need to organize.
I have a number of excel sheets and a hierarchy of folders and I would like to move these excel sheets into the folders based on keywords in a sentence in cells A1 and B1. An example of these folders is (Finance Department > Headcount > Percentages > 1999). I would like the tool/script to move the folder into that directory if the keywords “Finance Department” AND “Headcount” AND “Percentages” AND “1999” are located in the sentence in cell A1 which would look something like “Headcount numbers across all branches in percentages” and cell B1 would look like "Finance Department 1999"
Is there a macro I could use? Maybe some software that would help?
Bookmarks