J
jimnyo
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel have a budget workbook w/12 worksheets, 1 per month. i have a row of starting totals for each month. how do i copy the starting total in january's worksheet and paste it across the following months' worksheets in increasing months? Ex: in january's worksheet, cell A2 has the total of $100. in february's worksheet, the formula in A2 is: "=100+Jan!A2". how do i copy/paste the formula across the rest of the worksheets so that they read "=100+Feb!A2", etc. w/o having to manually enter in the month? also, the entire A row has several of these totals w/corresponding cells that have the reference to the jan! worksheet, so i was hoping to copy the whole row and paste and have all the formulas paste in succeeding order. i've done it once before, yeeeearrrrrs ago and can't remember how. thanks for your help!