Not sure if its possible,
I have a master workbook which logs all potential new business.
It logs NAME, REP, COMPANY, PHONE, ACCOUNT MANAGER, POSTCODE & COMMENTS.
It currently does this using INDIRECT functions.
The information comes via emailed workbooks. I open the emailed workbook, then type the filename into A1 (or whatever row is the next available empty one)
Then the INDIRECT functions populate the relevant cells. I then PASTE VALUES and save.
I get about 15 emails aday, and combined, it takes up a fair amount of time.
so,
what im thinking is, If I save all the work until the end of the day, then open ALL files I have received,
Would it be possible to create a macro, assign it to a command button on the master workbook, and when clicked,
It systematically retrieves the filenames of all open workbooks, and paste them into column A one by one, populating the cells, then copy & paste values?
How much work would be involved for a macro like this?
thanks.
Mike.
Bookmarks