Jamie,
Normally data isn't kept in a list AND in a separate worksheet for each
record in the list. It's redundant data, and can be a bit messy. If this
is output only, you can make a single "form" using VLOOKUP functions to
locate the correct record and return the data. You could then lay out the
form by putting these wherever you want. You'd have an index (some cell
with the record number you want -- and the record number (or something
unique) would have to be in the list so VLOOKUP could find it). But this
solution is output only -- you can't use it to update the list. Your
updates would have to be done to the list (You could use Data - Form for
that). To be able to use this "form" to update the list, you'd have to
write some code, or make a UserForm (also requiring code). Access does this
stuff with no code, and is likely a better solution for this application.
If this is for print purposes, Word can use your Excel list in a Mail Merge.
You 'd get one sheet per record, and could lay it out pretty much the way
you want. It has a query capability to allow you to select only certain
records.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
jamie_m_jr said:
I have a worksheet with a list of names and addresses. I would like to
add each name and address to a form. Each individual name would have it's
own worksheet. The positions of the data in the list and where they would
fit into the form are currently in a different number of cells apart. Also,
some of the addresses are four lines and some are just three.
I'm not sure if this is possible, but it sure would be nice...Thanks for
any help.
