Hi ... Basic question here.

I have a maiing database with over 14,000 records (each row is one
record). Each column contains respective data such as name, address,
city, etc.

How can I reformat each row (each person) to display as one page with a
layout that my salespeople can printout as a contact sheet?

I also use Filemaker Pro which allows a database view with row after
row of data, but also a worksheet view with columnar data laid out as
one page per record with cell data located anywhere I specify.

Is this possible with Excel?

Thanks.
i am spardacus

:)


--
spardacus
------------------------------------------------------------------------
spardacus's Profile: http://www.excelforum.com/member.php...o&userid=26233
View this thread: http://www.excelforum.com/showthread...hreadid=395277

this is an excel vba programming issue
look in the programming section for ideas

Lots of different ways, none are that hard if you know VBA
if not go to J-Walk.com & buy the book, read it

general process:
user selects a cell in the row
user engages Macro/code module
code:
make sure only one cell selected
screenupdating=false
add sheet
put info from selected row/column into new sheet cells
(format and layout?)
Print newsheet
delete new sheet
screenupdating = true

"spardacus" wrote:


Hi ... Basic question here.

I have a maiing database with over 14,000 records (each row is one
record). Each column contains respective data such as name, address,
city, etc.

How can I reformat each row (each person) to display as one page with a
layout that my salespeople can printout as a contact sheet?

I also use Filemaker Pro which allows a database view with row after
row of data, but also a worksheet view with columnar data laid out as
one page per record with cell data located anywhere I specify.

Is this possible with Excel?

Thanks.
i am spardacus

:)


--
spardacus
------------------------------------------------------------------------
spardacus's Profile: http://www.excelforum.com/member.php...o&userid=26233
View this thread: http://www.excelforum.com/showthread...hreadid=395277