Delete From first sheet and copying to other

Closed
Rehan - Apr 5, 2012 at 02:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 5, 2012 at 05:30 AM
Dear Friends,

i have problem with excel sheet.

i have two excel sheet that have lots of data.
i want to delete from first excel sheet then need to update on other sheet automatically.

Like.

sheet1

sr. name address phoneno
1 a d4 1233
2 b d4 1233
3 c d4 1233
4 d d4 1233
5 e d4 1233

sheet 2.
sr. name address phoneno

****************************
if i delete the data from sheet1 (after delete the data. 3rd record is deleted )

sheet 1
sr. name address phoneno
1 a d4 1233
2 b d4 1233
4 d d4 1233
5 e d4 1233

sheet2
sr. name address phoneno
3 c d4 1233

**********************
we need like that.
please help me. its very urgent.

thnx in advance.
Rehan

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 5, 2012 at 05:30 AM
Rehan,
You may have to code for that in
Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

event, on the sheet deletion happens.

Or you have some formula (like a match) on sheet2 and code for this event

Private Sub Worksheet_Calculate()

End Sub
0