using Excel as a database

  • Thread starter Thread starter Elwood Dowd
  • Start date Start date
E

Elwood Dowd

can someone point me in the right direction here...

I would like to have a workbook with, say, 2 sheets. the first would
be a form, for a user to enter data into different cells. I would like
to be able to have that data then added to a table (database) on the
other worksheet.

So, for example, if 5 people enter info in the first sheet (one at a
time), the table on sheet 2 will have 5 new roes added to it. I'm
basically looking to have a very small database setup.

Alternatively, I could create a VBA form, and use that for entry, but
I'm not sure how to set it up so it adds to the database table each
time.

any help is appreciated.

C
 
Hi C

Once the table is set up, Excel's own data entry form (menu Data > Form) is built to do
just this -and more. Suggest you try that first.
 
Back
Top