Hi;
I could really use a macro that copies several specific cells (could be number, text, or date) from the workbook that is currently open (I'll need to do this from many workbooks that aren't even created yet) to the next blank line in a different workbook called ABC_summary. e.g. I'd like to copy contents from:
cell A1 from the open workbook to cell A1 in ABC summary
cell G3 from the open workbook to cell B1 in ABC summary
cell H5 from the open workbook to cell C1 in ABC summary
etc. etc. ...
then from the next time I open another workbook I'd like to copy:
cell A1 from the next open workbook to cell A2 in ABC summary
cell G3 from the next open workbook to cell B2 in ABC summary
cell H5 from the next open workbook to cell C2 in ABC summary
and so forth....
I might be able to figure this out but I guess I'm stuck on identifying the next blank line...
Can you help me?
Bookmarks