![]() |
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! |
All times are GMT +1. The time now is 08:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com