Copy data to new sheet.. more tricky than I imagined
Closed
ElPolloDiablo
Posts
2
Registration date
Friday 6 March 2015
Status
Member
Last seen
6 March 2015
-
6 Mar 2015 à 02:52
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Mar 2015 à 00:21
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Mar 2015 à 00:21
Related:
- Copy data to new sheet.. more tricky than I imagined
- 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
- Little alchemy cheat sheet - Guide
- Tmobile data check - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
6 Mar 2015 à 06:30
6 Mar 2015 à 06:30
Quote
auto populate certain cells
unquote
what is meant CERTAIN cells.
Suppose your main data is in sheet 1 and you want to copy all the data in sheet 2 try this
Sub test()
With Worksheets("sheet1")
.Cells.Copy
With Worksheets("sheet2")
.Range("A1").PasteSpecial
End With
End With
End Sub
auto populate certain cells
unquote
what is meant CERTAIN cells.
Suppose your main data is in sheet 1 and you want to copy all the data in sheet 2 try this
Sub test()
With Worksheets("sheet1")
.Cells.Copy
With Worksheets("sheet2")
.Range("A1").PasteSpecial
End With
End With
End Sub
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
7 Mar 2015 à 00:21
7 Mar 2015 à 00:21
if it is nots oft repeated job it is not worth a macro
6 Mar 2015 à 06:45
And I'd need it to copy that data to an automatically created sheet. (that the code I posted creates) That's the tricky part. Any idea how that can be done?