How to transfer data from one sheet to anoth [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!