Vba for copy from sheet 1(form) then paste to sheet 2(database)
Closed
Lloyd Grey
-
Aug 18, 2015 at 04:47 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Aug 18, 2015 at 08:45 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Aug 18, 2015 at 08:45 AM
Related:
- Vba for copy from sheet 1(form) then paste to sheet 2(database)
- Gta 1 download - Download - Action and adventure
- Fnaf 1 download pc - Download - Horror
- Tentacle locker 2 - Download - Adult games
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Aug 18, 2015 at 08:45 AM
Aug 18, 2015 at 08:45 AM
Hello Lloyd,
Without seeing a sample of your actual work book, try the following code in a standard module to see if its at least close to what you would like to do:-
I'm assuming that you would like to transfer the whole data set as one "block" of data.
You can peruse my test work book at the following link:-
https://www.dropbox.com/s/ll5r96m1u6fssvv/Lloyd%20Grey.xlsm?dl=0
If it is not what you are wanting to do, then please upload a sample of your work book (be careful with any sensitive data) so we can see exactly what you would like to do. You can upload a sample using a free file sharing site such as DropBox, ge.tt or SpeedyShare.
Cheerio,
vcoolio.
Without seeing a sample of your actual work book, try the following code in a standard module to see if its at least close to what you would like to do:-
Sub CopyIt()
ActiveSheet.UsedRange.Offset(1).Copy Sheet2.Range("A2")
Sheet2.Select
End Sub
I'm assuming that you would like to transfer the whole data set as one "block" of data.
You can peruse my test work book at the following link:-
https://www.dropbox.com/s/ll5r96m1u6fssvv/Lloyd%20Grey.xlsm?dl=0
If it is not what you are wanting to do, then please upload a sample of your work book (be careful with any sensitive data) so we can see exactly what you would like to do. You can upload a sample using a free file sharing site such as DropBox, ge.tt or SpeedyShare.
Cheerio,
vcoolio.
