Sheet1 is now called: CUSTOMERS
Sheet2 is now called: JOBS
Sheet3 is now called: REPORT
In the CUSTOMER sheet I record all the usual details: CUST-ID, NAME, ADDRESS, etc
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?
Your help and advice would be greatly appreciated.
Many thanks, James Elliott
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 18/02/2005
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
