i have an excel doc with something like...
title1 title2 title3
blah1 blah2 blah3
next1 next2 next3
(hope that formatting will come out remotely well)
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.
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 "[blah2.xls/doc]"
does anyone know if excel can do this?
fanx
title1 title2 title3
blah1 blah2 blah3
next1 next2 next3
(hope that formatting will come out remotely well)
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.
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 "[blah2.xls/doc]"
does anyone know if excel can do this?
fanx
Facebook
Twitter