creating a document from an xl row

[Guest]

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

does anyonw know how i can do this?

thx

 

[Markus Scheible]

Good morning Phil,

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

does anyonw know how i can do this?

This really sounds like a task for a PivotTable... with
this tool you could solve that problem without VBA.

Best

Markus