On Mon, 2005-02-21 at 17:36, James Elliott wrote: [snip] > In the JOBS sheet I record the DATE, JOB-No., CUST-ID, TECH-TIME, etc. I > pull up the Customer's Name by using VLOOKUP with CUST-ID as search > criterion > > I used to type the reports using an OOo Writer Template, but this meant > typing in the Job Number, Customer Details, and all the stuff that was > already recorded in my spreadsheets, so I created a REPORT spreadsheet which > could pull up all these details using VLOOKUP. > > THE CHALLENGE > > In the REPORT spreadsheet I enter the JOB No. and VLOOKUP fills in most of > the details and I just have to type a little bit at the bottom. > > However, in the CUSTOMERS spreadsheet there are hundreds of customers; > > in the JOBS spreadsheet there are thousands of JOBS; > > in the REPORT spreadsheet there is just one report - so what I am doing at > present is printing that report and then blanking it out so that I can use > the sheet again for the next customer's report. > > If I want to save a copy of all reports on my hard disk then I have to scan > each report and save it as a JPEG or some other graphic format > > Is there some way of saving just the REPORT sheet and not the whole book? > -- or -- > is there a better way of doing what I am doing?
I can think of several approaches: 1. Export as pdf 2. A macro to export the info to Writer 3. Have the report page as a template that has links back to the main file. Thus the report is already a separate file, but is linked. 4. A macro that copies and pastes special as values to a new file with just the report sheet. Hope this helps - Ian Laurenson --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
