QUOTE(WeaponX @ Oct 15 2005, 10:48 PM)
Can you provide a short sample of what you want? It sounds confusing, but do you want something like this:
Add Column 1 and Column 2 and put result in Column 3
Add Column 4 and Column 5 and put result in Column 6
.....
If so, why don't you just put the formula in Columns 3, 6, 9, etc... now and then just copy the formula all the day down the spreadsheet. So now when you enter data in Columns 1 and 2, 4 and 5, .... they will automatically be calculated on the fly.
Yes, just putting in an addition formula in your column 3 to add column 1 and 2 would be the easiest way to add the forst two columns.
Click on the column 3 frost row and type "=A1+B1" and hit enter
Then get your mouse to the bottom right corner of C1 and click and drag. This should apply the formula the the entire column 3 on all rows through which you drag it.
I looked up the help section, but I haven't come across any wat to do this entirely automatically as yet.
Comment/Reply (w/o sign-up)
