Copy data from 1 excel workbook to another based on certain criteria

Hello all,

I could really use the help of those much smarter than I.

I need to create a master list of items that are coming in from many other workbooks. These other workbooks are all in the same, terrible format (Not my fault it was made before I arrived), but I cannot do much to change that. I have attached the worksheet that I need to get the data from. I need to grab the Vendor, Contact, Contact telephone, Equipment, and Req'd Date when there is a Req'd Date (So if the Req'd Date is blank, it is not being ordered and as such should be left out entirely). I also need to get the address of either the site or the warehouse (listed at the top) based on the Delivered to Site or Warehouse column.

Then for each row that contains a req'd date, I need to paste the data above into the first unused line in a different workbook.

Any help would be much appreciated as I have no VBA experience and not the slightest clue where to begin.

Thanks,
Matt

I should also have mentioned that each of the workbooks coming in are originally the same, just blank, and then someone fills it out and sends it back. Therefore, a macro to export the data would be included in all of the incoming workbooks.

Matt, welcome to ExcelFox

This can be done. But the entire requirement looks more like a project request than a request for help. Maybe offering some incentive might get you going. In the meanwhile, can you clearly mention the cell address of each of the cells you require to be captured from above row 28 (the ones below are straight forward).

I do not think there is any way to add more than 256 columns... you probably could use keys to uniquely identify records, and split the columns in to multiple tables. You could also check if Access 2013 allows more than 256 columns.