On Sat, 2006-05-06 at 13:55, G. Roderick Singleton wrote: > On Fri, 2006-05-05 at 18:29 -0500, Fred Grant wrote: > > 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? > > Upgrade to at least 1.1.5 or, better, 2.0.2 and try again. If I delete the data from the cells I no longer want included and then move the other cells up or down as needed, it works OK. Did anyone try a simple example with a newer version to see if the problem is solved?
Thanks, -- Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
