Hi Team,,

I have 2 excel worksheets in a workbook and i want the data of both the sheets copied in a new sheet called summary sheet.

I have 3 columns in all the 2 sheets i.e. Emp SNo,Emp Name & Emp Id.
the column no's are B,C & D and the range starts from B3.

The data should get deleted from the summary sheet and then new data should get uploaded

Need VBA code for the same with steps as i am a Layman.

Regards,
Aparna