On Mon, 2005-02-21 at 19:18 +0800, James Elliott wrote: > I again Ian > > I tried the Template approach and it seemed to work fine, but when I looked > further into it, the Template was in fact the whole multi-spreadhseet, so > for every report I am saving my entire database which includes details of > hundreds of other customers not involved with the report. > > I tried making just that sheet into a Template, but all the formula cells > then contained the REF? error. I could run both spreadsheets side by side > and link them but the formulas become horrifically long. > > I think I will have to stay with using my VLOOKUP sheet, printing out the > report, and then clearing it ready for the next one.
Have you tried the DataPilot? See page 217 of the user guide to see if this will help you make your report without the extra sheets. [snipped] -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
