Build Table using selected fields from Table of data

Hello,

I have a set of data that I can extract from my accounting system. I need to be able to take certain columns from that data and create another table. The file is attached. The JDESqFtg tab is the data out of the system. The Tenant Tax Recovery Summary tab is what needs to be built. I can build most of it with formulas but I want the user to be able to drop in the data extract into this template file. Click an update table button and it will pull in all of the updated information each time. The fields that need to be used are highlighted on both tabs. For the dates it gets a bit tricky. I need it to pull the begin date and end date but I need the Move-in Date and Vacate Date fields to trump the begin and end date fields if it is populated. The code I have simply does End(xlUp).Select and copies and pastes it into the fields but does it one column at a time and I cannot figure out how to get the date logic to work. Any suggestions?

Regards,

Anthony

Try the attached

It always amazes me how helpful this forum is. It has taught me a lot. The responses are always timely and very useful. Thanks for the code it works great. I made one change which was just rearranging the order of the columns it pastes.

a = Array(.Cells(i, "D").Value, .Cells(i, "E").Value, .Cells(i, "A").Value)

Martin,
You are welcome!