Hi, Imagine two data tables. One exists from $A$1 to $P$500, the second from $AA$1 to $AP$500. Within each table there is a set of 5 columns I need to use as a single, larger table. $F$1 to $J$500 and $AF$1 to $AJ$500. I could copy the second table below the first making a single large table but before I do that I was wondering if there was a way to simply describe these two address ranges as one larger range using some function? (I.e. - effectively $F$1 to $J$1000.)
Is there any support in Calc for creating essential a virtual address range that grabs data from different parts of the spreadsheet? Thanks, Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
