how to set up a database?

[Rachael]

I used to know how to do this in old word versions...

I have an excel worksheet that I have to fill out about
20 questions regarding insurance claims. It's akward to
keep entering the info, then clicking on the next box,
entering the info and so on.

How do I create some kind of data entry form that I can
enter all the info into, and have it plug back into my
excel worksheet?

I hope it's not toooooo hard!!

Thanks

 

[Harald Staff]

Hi

Select your input cells. Unprotect them with menu Format > Cells >
Protection, remove Locked. Then protect your worksheet with Tools >
Protection > Protect worksheet menu.
Now she'll jump between the entry cells only. (Ensure you've enabled "Move
selection after enter" in Tools > Options > Edit menu.)

If no good, if your data is on real data format (a list, one row only for
every record and distinct headers on top) there's always a form ready to use
in the Data > Form menu.

If not this either, then you must vreate a Userform. It involves some VBA
programming, is great learning and great fun, but don't expect it ro run
flawlessly the first evening.

HTH. Best wishes Harald

 

[Judy Freed]

This might help.

http://www.uncc.edu/SYSDEV/HowTos/Excel/Creating Data Forms in Excel.htm

Judy Freed

 

[Guest]

Hahah...I tired your first suggestion. Didn't work.
Keeping in mind..this is a weirdly formated page, so it's
not set up like a table or chart, it has answer boxes
randomly all over the page.
I don't have a "protect worksheet menu". I have "protect
sheet" and "protect work book". But I don't know what I'm
supposed to do with the menus that come up.
(I have office 2003)

I want it work sort of like mail merge in word, with a
database and individual entries.