Need to create a macro
Closed
bettyjk
Posts
1
Registration date
Thursday February 5, 2015
Status
Member
Last seen
February 5, 2015
-
Feb 5, 2015 at 06:37 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 6, 2015 at 08:10 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Feb 6, 2015 at 08:10 PM
Related:
- Need to create a macro
- Create skype account with gmail - Guide
- Create snapchat account - Guide
- Create a yahoo email account for free - Guide
- Create instagram account - Guide
- Create hotmail account - Guide
2 responses
MrIstar
Posts
280
Registration date
Wednesday June 19, 2013
Status
Contributor
Last seen
April 28, 2016
Feb 6, 2015 at 09:46 AM
Feb 6, 2015 at 09:46 AM
Hi there !
I was looking through Internet and I found the solution.
Just take a look at This Page.
Good Luck !
Open your eyes, look within. Are you satisfied with the life you're living?
*Bob Marley
I was looking through Internet and I found the solution.
Just take a look at This Page.
Good Luck !
Open your eyes, look within. Are you satisfied with the life you're living?
*Bob Marley
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Feb 6, 2015 at 08:10 PM
Feb 6, 2015 at 08:10 PM
Hello Betty,
Do you need all the data in Sheet1 to be transferred to sheet2 at once or do you need certain rows of data to be transferred at a time?
If you could upload a sample of your work book, it would be easier for us to see what you would like to do. You can upload using a file sharing site such as DropBox. Be careful with any sensitive data.
As a starting point, this code may help:-
This code will transfer all your data from sheet1 to sheet2 at once and clear it from sheet1.
Let us know if we can help further.
Regards,
vcoolio.
Do you need all the data in Sheet1 to be transferred to sheet2 at once or do you need certain rows of data to be transferred at a time?
If you could upload a sample of your work book, it would be easier for us to see what you would like to do. You can upload using a file sharing site such as DropBox. Be careful with any sensitive data.
As a starting point, this code may help:-
Sub BettyDataTransfer() With Sheet1.UsedRange.Offset(1, 0) Sheet2.Cells(2, 1).Resize(.Rows.Count, .Columns.Count) = .Value End With Sheet1.UsedRange.Offset(1, 0).Clear End Sub
This code will transfer all your data from sheet1 to sheet2 at once and clear it from sheet1.
Let us know if we can help further.
Regards,
vcoolio.