How to transfer data from one sheet to anoth
Closed
suresh
-
Jul 22, 2009 at 10:11 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 08:35 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 08:35 PM
Related:
- How to transfer data from one sheet to anoth
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Google sheet right to left - Guide
- Little alchemy cheat sheet - Guide
- How to screenshot excel sheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 22, 2009 at 08:35 PM
Jul 22, 2009 at 08:35 PM
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.
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.
