On Tue, 2006-04-25 at 16:42, Fred Grant wrote: > 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 exactly what I needed. Ross, thanks for > your grasp of what should have be obvious to me.
Something strange has happened here. If I delete a row on the master (data) sheet, it gives an error on the report sheet where that row used to be. The same thing happens if I delete cells instead of deleting the row. It's as though the two are hard linked to each other. I'm using 1.1.2 on Fedora Core2. Any thoughts? -- Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
