How to transfer data from one sheet to anoth
Closed
suresh
-
22 Jul 2009 à 10:11
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Jul 2009 à 20:35
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Jul 2009 à 20:35
Related:
- How to transfer data from one sheet to anoth
- How to copy data from one excel sheet to another - Guide
- Excel move data from one sheet to another - Guide
- How to copy data to multiple worksheets in Excel - Guide
- Free fire transfer - Guide
- How to check t mobile data - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
22 Jul 2009 à 20:35
22 Jul 2009 à 20:35
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.
