Hey guys,

Im having a little trouble writing a VBA excel macro that, when a button is pressed, copies data from one (open) excel data file to a different (open) master file that will aggregate the data. The data files will we opened separately and the button will be pressed each time.

The information in each data file needs to be copied from row 3, column A until end of data, and the pasted AT THE END OF ANY DATA in the master file starting at column.

For each of the data files' data; In column A I need the date created from the properties information. In column B I need the time created (to the minute) from the properties information. In column C I need the data in cell E2 of the data file to also be copied next to that files data.

There are around 50 data files I need to copy into the master file.

If anyone can do this I would really appreciate your help.