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 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Aug 18, 2015 at 08:45 AM
Hello,

newbie here.

Please help me by giving a vba that could automatically make a database.

I have a form(sheet1) detailed with various info and I would like it to automatically
copy and paste to sheet2(database).

the filled in sheet1(form) is use every now and then so i need a vba that could copy all the details and paste it to database.

Thanks.
Lloyd



1 reply

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250
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:-


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.
0