copying entire data from one workbook to another workbook

[sureshrouniyar]

Can you help me providing me a code/macro for copying data from one workbook (e.g 'Entry.xlsx') to another existing workbook ('Report.xlsx') with same format.

I will be very much thankful in this regard

[patel]

It's not very clear, why not copy file and rename it ?