Extract data from each record and put into another worksheet

**Dave32** · 03-28-2008, 10:59 AM

I need to input data into worksheet 1 "dataentry" and then extract the data from that record into worksheet 2 and then repeat this for the next record etc..

I would use the data list option to enter data but I can change the form in worksheet 1 (this has been set up my company)

Each record has a unique identifier, all data inputed will be in the green cells.

See attached file

Dave

**royUK** · 03-28-2008, 11:18 AM

Are you looking for a VBA solution?

**Dave32** · 03-28-2008, 11:32 AM

Roy,

Ideall not VBA, but if that is the only solution I can add the Macro. The other issue is that this form will be filled in by person different to the one creating the database.

Let's give an example you have 10 sales guy, each will fill in a form and then you need to collate that info into one spreadsheet. One line of data for each for filled in.

The form will not be changed once it is finalised and will be locked. I will also use drop down tables to avoid incorrect data entries.

Thanks,

Dave

**royUK** · 03-28-2008, 11:33 AM

This code should get you started using two buttons from the Controls Toolbar

Please Login or Register  to view this content.

**royUK** · 03-28-2008, 11:35 AM

Originally Posted by Dave32

Roy,

Ideall not VBA, but if that is the only solution I can add the Macro. The other issue is that this form will be filled in by person different to the one creating the database.

Let's give an example you have 10 sales guy, each will fill in a form and then you need to collate that info into one spreadsheet. One line of data for each for filled in.

The form will not be changed once it is finalised and will be locked. I will also use drop down tables to avoid incorrect data entries.

Thanks,

Dave

I would suggest you keep the one workbook with the database and input sheet. Give each rep a template containing only the input sheet for filling in. When they submit this to you, simply copy and paste to the master input sheet then run the macro to add to the database.

**Dave32** · 03-28-2008, 02:55 PM

Roy,

Thanks for your help with the data entry form, I have some more questions but will get back to you on Monday.

Thanks,

Dave32

**Dave32** · 03-31-2008, 03:41 AM

Roy,

Thanks for your help on the form, I have now started another thread as I am afraid I need a little more help.

Maybe you can help me?

Dave32

**Dave32** · 07-31-2008, 05:31 AM

Roy,

Thanks for helping me with this code. I have posted a new thread with another problem.

"Copying rows of data into different cells in a new worksheet"

I am wondering if it is possible to adapt the code you gave me so instead of taking data from a form and putting it into 1 row of text. The data input is taken from a row of data and then put into a form. I guess a VBA algorithm needs to be created here. I do not how to do this, so hopefully yourself or somebody can help me.

Dave32