On Sun, 2006-04-23 at 19:30, Ross Johnson wrote: > On Sun, 2006-04-23 at 17:57 -0500, Fred Grant wrote: > > I have a spreadsheet with data in cols A1 through B225 (2 cols wide). I > > sort the data based on col A for one report and based on col B for a > > different report. I cobbled together a macro that pastes the first 52 > > pairs of values in col A of a new sheet then I get the next 52 pairs and > > paste in col C of the new sheet. The next 52 pairs then go under the > > data in col A of the new sheet and finally the last 52 data pairs go > > under the data in col C. This gives me a nice compact report. > > > > My question is, is there built-in functionality in calc to do this? I > > realize that a database program might have some advantages here but for > > now I'm sticking to calc. > > I'm probably not understanding your scheme, but can't you setup > permanent cell references in the new sheet pointing back at the data > sheet? The format that you described seems to be sufficiently fixed to > be able to do that. > > E.g. In the new sheet: > > Cell A1: =DataSheet.A1 > Cell C1: =DataSheet.A53 > Cell A53: =DataSheet.A105 > > etc. > > Then when you sort the data sheet, the new (Report) sheet should > automatically update. > > Ross > That's slap my open palm up against my forehead exactly what I needed. Ross, thanks for your grasp of what should have be obvious to me.
-- Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
