Worksheets & Forms

[Glenn]

I would like to use an Excel Workbook to do the following:

1) Have one worksheet that is more a less a "database" of information.
2) Have a second worksheet that is a form that is filled in using the data
from one of the rows in the database.

For Instance,
Worksheet 1 Would have columns such as:

Record # Name Address City State
ZIP Contribution

And Worksheet 2 would be page that said something like

Name:
Address
City:
State
ZIP
Amount of Contribution

I know how I could do this by merging it into word, but for simplicity sake
for the user, I'd like to keep them in one place.

I'm thinking that there could possibly be some type of box on worksheet 2
that is a dropdown of the Record #'s, and that when the user picks the
record # it could populate the worksheets.



Is this possible? Could someone please point me to directions?

Thanks.

 

[Bob Phillips]

You can do it all on one sheet.

Add your headings then goto Data>Form... and you will get a built-in
dataform.

 

[Glenn]

Thanks, but hat's not quite what I meant.

I had an actual form that needs to be populated with the data from the
cells. I don't want to fill the data in on the form, I want it to be filled
in from the cells so that I may print it (on letterhead, etc.)

 

[Gord Dibben]

Glenn

Sounds like VLOOKUP could do the trick.

For more on that Function see Debra Dalgleish's site.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation lists with drop-down box for
entering the code numbers.

http://www.contextures.on.ca/xlDataVal01.html

Might be useful.


Gord Dibben Excel MVP

 

[Charles]

Hi Glenn
I have a similar situation which works with a button which runs a macro.
The macro copies fields from the database sheet and pastes them on a report
sheet which is then printed.
I loop through the database until all records have been copied and printed.
Charles