transferring formulae between worksheets

[m-r]

Advance apologies, I'm a TOTAL klutz -- and I can't even find the info. I need in the Excel help files !
Please; how do I bring forward a whole row of column formulae (July totals) from one worksheet to another (beginning of August) ?
(Hope no-one is offended by reading so banal a query !)

 

[kskinne]

Hi, welcome to the board

Could you give a little more detail as to exactly what you are trying to accomplish?

thanks,
kevin

 

[m-r]

I'm making bookkeeping spreadsheets, one worksheet for each month. I want to be able to carry forward a row of totals from the bottom of each month to provide the top row of the next month, onto which will be added that month's totals, and so on ... But I don't know how to carry forward all the totals as formulae rather than merely manually copying them.

 

[kskinne]

this is easy enough, here's what you do:

say for example that on each spreadsheet file, your beginning balances for the month are in row 1, and your ending balances for the month are in row 30. now let's say that you have two files, january.xls and february.xls. to get the ending balances for january.xls cell A33 to appear in the february.xls file as the beginning balance in cell A1, you would follow this procedure:

1. open both files in excel
2. go to february.xls, cell A1
3. click the equal sign (=), then go to january.xls, row 33, select it, and press the enter key.
4. you would notice that a formula has appeared in cell A1 in february.xls, which is a link between the two files, that contains a cell reference to january.xls, cell 33.

just follow this procedure for all of the other cells you want to link (just change the names to fit your circumstance), or once you are familiar with the formula to establish the link, you can just type it in. good luck!

kevin

 

[m-r]

Thank-you a thousand times, O wise moderator -- your help is GREATLY appreciated ! I mean, *G R E A T L Y* !!!