Display each row as one recrd per page

[spardacus]

Hi ... Basic question here.

I have a maiing database with over 14,000 records (each row is on
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
layout that my salespeople can printout as a contact sheet?

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

Is this possible with Excel?

Thanks.
i am spardacus

:

 

[Guest]

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