Create a form in excel so I can enter data using Data>Form

G

Guest

I am trying to create a database in Excel with headers so that I can enter
new data using the Form feature. I am running Excel 2003. I can create the
named range but when I click anywhere in the range and then select Data>Form,
I get an error message that says "Database or list range is not valid." I am
not sure what I am doing wrong.

Lynn
 
G

Guest

Dave, this was helpful. I renamed by named range database and the form
worked. Thanks!
Lynn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
Creating an Form to enter data 3
Dynamic Excel data into locked Word form 0
VBA - retrieve data on last create named range from previous inserted named range 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Data in Access; Form in Excel - can I use mail merge to combine? 1
Macro to bring up Data Form 1
Form and protect sheet 2

Top