I'm trying to develop a macro that does a very specific task. I have an ever changing number and list of workbooks that I need to open, copy a set of cells that have data in them, and the paste into the firsst empty cell on a "Master" workbook.
Name of the master workbook is also continuosly changing. Set of cells on the source workbooks that I need to copy will always start in cell "A5:H5". But the number of rows will be continously changing.
What I really need it to do is copy from all open workbooks, into the "Master" workbook.
It will always paste into columns A:H and the row will always be the first empty row in the book.
ANY HELP would be greatly appreciated. This is an extremely tedious task with over 300 source workbooks coming in every day.
Name of the master workbook is also continuosly changing. Set of cells on the source workbooks that I need to copy will always start in cell "A5:H5". But the number of rows will be continously changing.
What I really need it to do is copy from all open workbooks, into the "Master" workbook.
It will always paste into columns A:H and the row will always be the first empty row in the book.
ANY HELP would be greatly appreciated. This is an extremely tedious task with over 300 source workbooks coming in every day.
