Hello,

I am attempting to semi automate some reports that my company uses in excel. Currently I have to open a workbook(raw data), select and copy about 200 cells in a column, open a different workbook(report) and paste the cells into a column. This isn't a big deal and easy to do this but we often have to do this about a hundred times a week. The raw data workbook is always uniquely named a 6 digit number so 123456.xlsx for example. The columns are always in the same place and the cells are always in the same place. Column B, cells 4 through 200 in raw data is copied into column B, cells 4 through 200 in the report.

Is it possible to get or copy the data from the raw data workbook that is named in cell D1 and paste or entered into the report workbook? It would be nice if this could be done without even opening the raw data workbook at all.

This might be more into the realm of macro but I'd thought I'd try for a function option first. I feel like this is almost in the realm of using vlookup but I haven't gotten anything to work yet.

Thanks in advanced for any replies.