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. Thanks -- Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
