Copy Data from a fixed form of data sheet into a master excel sheet.....

Hi,
I have a data in fixed excel template. Each time when the data will be changing i want the master sheet to be updated automatically but keeping the previous data in the master sheet. So basically the new data needs to start from next empty row

Please find the data template in the attachment.

Basically i need the data in the sheet 2 to be transferred in to sheet 1 but each time the data will be changing in the sheet 2 the previous data should not be erased from sheet 1 and the new data should be updated in sheet 1.

Thanks alot.

Hi Arlette,

I've noticed this topic, which has almost a similar problem as my topic:

http://www.excelforum.com/excel-prog...73#post3049473

Are you able to assist me as well in this?

Kind regards,
Peter