How to transfer data from one sheet to anoth

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
i HAVE A PROBLEM IN EXCEL.tHIS IS EXPLAINED AS BELOW--
I am entering cite details into my sheet.When i enter a cite details in main sheet,that cite details(total row) should transfer from this main sheet to that particular linked cite sheet.
So can any one solve this problem for me.

Thanks in advance

Suresh.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
needs more details.anyhow what you need is an event handler or event code
if you right click the main sheet tab and click view code you get that sheet code.
if the left hand side arrow choose worksheet. on the right window arrow choose "change"
in that your write the code some thing like this

Private Sub Worksheet_Change(ByVal Target As Range)
target.entirerow.copy
workshseets("link name").cells(rows.count,"a").end(xlup).offset(1,0).pastespecial
End Sub

this has to be tweaked somewhat for that more details or a small extract of your main sheet is required. anyhow I am sure you can work on the above suggestion.