Hi All!
So we have about 40 Excel files that we use for employee time sheets. Instead of opening each file and clearing specific cells, is it possible to run one macro across each file?
I'd like to clear contents of cell "In" and "Out" columns and change the date cell L2 to the beginning of the next pay period.
If at all possible, I'd like to NOT have to move the files into a separate folder.
Bookmarks