Copy data to new sheet.. more tricky than I imagined
Closed
ElPolloDiablo
Posts
2
Registration date
Friday March 6, 2015
Status
Member
Last seen
March 6, 2015
-
Mar 6, 2015 at 02:52 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 7, 2015 at 12:21 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 7, 2015 at 12:21 AM
Related:
- Copy data to new sheet.. more tricky than I imagined
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Tmobile data check - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 6, 2015 at 06:30 AM
Mar 6, 2015 at 06:30 AM
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 June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 7, 2015 at 12:21 AM
Mar 7, 2015 at 12:21 AM
if it is nots oft repeated job it is not worth a macro
Mar 6, 2015 at 06:45 AM
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?