Create from to display data from another tab

[JHLou]

I am having some sort of mental block. I'm pretty sure there is a simple
answer to my problem, I'm just not seeing it.

OK, I have a spreadsheet that is 49 columns wide. (ouch) However, all this
data must be tracked. I do not have Access to simplify the issue.

I want to display the data in form view/format on a new tab in the same
workbook. We'll call the tabs Data and Display. All users will be able to
look at Display, perhaps even look up information via combo/list boxes,
print, but not edit. After Display is set up and functioning, I'll lock the
Display from editing without a password (locking I know how to accomplish).

I'm blocking on this:
After I create the Name drop down list, how do I get the other cells to look
at that cell and display corresponding data (like address, phone, etc)???

Then, can I have two or three drop down boxes that will all work in concert
with each other and the other fields? Here's what I mean: I want users to
be able to lookup a record by Name, Street Address, or Phone Number. I want
other information to be diplayed when any one of those things are selected
(like contact name, bank information, mailing address).

I have searched Help & Forums and it seems the answer must be too simple to
bother explaining - except I need it explained.

 

[Dave Peterson]

Have you thought about keeping all your data on a single sheet.

Then applying data|filter|autofilter. The users can use the dropdown arrows to
show the records they want.

In xl2002+, you can protect the worksheet, but allow the users to use the
existing autofilter arrows.

 

[JHLou]

Well, the data is 123 rows by 49 columns. Even Freezing Panes, the data is
still unweildy. Alas, in Access, this would be a no brainer. In Excel 2007,
I'm stumbling. There must be a way to display all those fields in a
friendlier format...? Even if I don't get the drop down box option. Perhaps
I'll just include some lookup/search boxes? Anything? Something? Help?

 

[JHLou]

I think I'm asking the wrong questions. Please allow me to try again.

I want to create a form to display data already entered. Said data is
located in my Excel spreadsheet that is 125 rows x 49 columns. This happens
to be records of tenants (address, contact information, billing, rent, etc.).

I want users to be able to see a tenant's information easily. Preferably on
one page. Even printing that one page to keep a hard copy in their
physical/hard file.

I am using Excel 07. I see easily how to create forms using Visual Basic.
The properties confuse me, a bit. None of the instructions I've read mention
anything about entering in RowSource or ControlSource. How is the form going
to magically know to what cell you are referring?

I found some really informative looking headers in my Help file but there
seems to be a glitch with the links. The linked info is either a blank page
or something seemingly unrelated to the title. So - here I am, begging for
some direction on the Properties Box & what sort of information should be
entered.
(I love the Help file that says something like, 'click in the field next to
the label and enter your data.' No more than that. {snort & eye roll})

Instructions (links) for Idiots kindly welcomed.

 

[Dave Peterson]

Maybe you can add Form to the QAT.

It may be enough.

If it's not...

Maybe you can design your own form and control everything that happens.

John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

And if that's not sufficient, then maybe you could design your own input
userform.

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Personally, I'd rather use the autofilter and have to scroll right/left to see
all my data. I'd be able to filter to show multiple rows.