creating a document from an Excel row
i have an excel doc with something like...
title1 title2 title3
blah1 blah2 blah3
next1 next2 next3
1)
i want to be able to click on the grey left-hand button for each row, and
generate a 1-page report for that row. eg, if i click on the left button next
to "blah", i want an excel page like
title1: blah1
title2: blah2
title3: blah3
to be printed out.
clicking on the button by "next" would give me
title1: next1
title2: next2
title3: next3
2)
And even better, going a bit further...this same page generated in a
directory which has the same name as one of the titles.
for example...
if "blah1" is the name of a customer and "blah2" is the model number of some
equipment, i want the generated page to be called "[blah1.doc/xls]", and for
this to be saved in a directory called path\blah2"
does anyone know if excel can do this? 1) is essential, 2) is highly
preferable
thanx!
|