Hi,

Can anyone help me with a macro which will help me collate data from multiple workbook saved in a particular location into a single worksheet. I have a data range which is not fixed in terms of number of rows and columns, then, how do i copy it. Currently i am doing it manually by selecting range using Ctrl + Shift + End. Can you suggest an VB code which will select the whole range in the sheet and paste it in the worksheet. Thank you very much.

VG