Hi everyone!
I have around 85 workbooks in 1 folder that I need to change the formatting in 1 column from date to currency. The trick is that none of the workbooks are named the same, and the sheet names are not the same either (every workbook and sheet contains the full name of the person receiving the workbook). Basically, I need column J in the 2nd sheet of every workbook to change from a date to a currency.
I'm attaching 2 workbook examples - John Doe is correctly formatted and Jane Doe represents the 85 workbooks in the same folder that need column J formatted as well. The folder where all of these files are located is: C:\Users\Jenna\Documents\Reporting\CH\VP Dash\Director Dashboards September 2014\
Can someone help me figure out an acceptable code that doesn't force me to have to have all of the 85 workbooks open at once?
THANKS!
Bookmarks