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

[Closed]
Report
-
Posts
1318
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 20, 2021
-
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
1318
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 20, 2021
238
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.