Brian Barker wrote: > At 17:23 06/06/2007 +0200, Jonathan Kaye wrote: >>Hi all, <snip> >>Any suggestions would be gratefully accepted. >>Thanks in advance, >>Jonathan > > o Create the required formula (=Sheet1.A1) in cell A1 of Sheet2. > o Select that cell and drag the fill handle across the top row of > the required eighteen columns. > o Edit I1 and P1 so that they refer to the required, other column. > o Click A1 and then Shift-click R1 to select the eighteen cells in > the first row of the required columns. > o Copy. > o Click the column header of column A and then Shift-click the > column header of column R to select the eighteen columns. > o Paste. > o Wait for Calc to paste the modified formulae into the cells. > o Wait a bit more. > o Keep waiting. (There is a lot of work to do.) > o Bingo! > > I trust this helps. > > Brian Barker Hi Brian, Yes, it certainly does or would help. As I replied to Anthony, the key is the "fill" feature which I didn't know about. You are absolutely right about the waiting but it's worth it. Thanks a lot for the help. Cheers, Jonathan -- Registerd Linux user #445917 at http://counter.li.org/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
