*sigh* Ok, I have no clue if this is even possible.
Ok, I have about 1500 Excel workbooks that I need to go through. I need to copy the content of cell E13 in sheet "Summary - Page 1". and paste this figure into my open workbook (levels.xls), accordingly to the account number and month the figure is from. In the 1500 workbooks, the account number is always cell C2 in sheet "Summary - Page 1", and the date is in J2 (same worksheet). SO this is what we got for the workbooks
C2 = Account Number (5 digits)
J2 = Date (in m/d/yyyy format)...altho all I want from it is the MONTH name
E13 = Dollar Figure
All in sheet "Summary - Page 1"
My open workbook I have set up like this...
A B C E
1 Account | January | February | March | etc.
2 11111 20,598.21
3 11222 25,458.25 69,256.25
4 12569
5 23691
Now I can manually select the file that I want to open. (Application.GetOpenFilename)...
But I want the code to see the content of C2, so it could align itself correctly vertically in levels.xls.......Then see the content of J2, and align itself horizontally in levels.xls....and then copy over E13 into where it falls
Thanks
Bookmarks