Database

**kbenstead** · 02-03-2009, 06:54 AM

Hi

I am very new to create forumals and i am trying to build a database which has two worksheets

1. Input Sheet
2. Request Database1

so basically what I am after is they fill out the form on the first page and which when they press the button at the end of the page transfers all the data to the database.

I can record a macro to do this but its but it keeps going to the first row.

Can anyone help.

Thank you in advance

Kim

**davesexcel** · 02-03-2009, 10:08 AM

Here's something to work with, notice the offsets, it tells how many columns to paste from Column A

Please Login or Register  to view this content.

**Garf** · 02-03-2009, 10:12 PM

Why don't you use MS Access it can do all this for you, create the tabel then create the user form when the user enters data it's automatically entered to the table, you can then create reports and queries to view your data.