Vba for copy from sheet 1(form) then paste to sheet 2(database)

Closed
Report
-
Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
-
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

Posts
1333
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 23, 2022
243
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