Hello

I am working on budgets for my business and am working off of 2 worksheets. The first (WS1) has specific line items, and the second (WS2) has the general budget information. Cells in WS2 are made up of formulas linked to WS1.

IN WS1 there are figures in cells B4 to B9, and in cells C4 to C9. I want to get the total amount of these cells from WS1 to only one cell in WS2 (i.e. the sum of B4-B9 into Cell A30 in WS2 and the sum of C4-C9 into Cell C30). This is the formula I am using (the actual name of WS1 is 2003bud detail )

=+'2003bud detail'!B4+'2003bud detail'!B5+'2003bud detail'!B6+'2003bud detail'!B7+'2003bud detail'!B8+'2003bud detail'!B9

I put this formula to cell A30 in WS2. I do that fine. This is working fine. Cell B30 is a percent figure. I want to copy the formula from A30 to C30, but when I do CTRL+C on Cell A30 and CTRL+V to C30, the formula goes from letter 'B' to letter 'D". In other words it is recognizing Column B when I paste to Column C - I DO NOT want to skip letters in my formula. I want to go from 'B' to 'C' . Can I do this even if the columns are not next to each other??

Thank You SO Much.

Peter