autofill / copy

[- Bobb -]

Making a spreadsheet and trying to figure how to easily populate the
formulas
Acroos the top have columns for 10000, 20000, 30000, etc
and down the rows have various percentages
Each cell is merely the top column value times the percentage.
I thought it simple until I tried to use autofill and BOTH variables
increase - I want the column input toi stay the same.

see attached for typical application that I'm trying to do.

[Paul B]

Bobb, Most of the people here want open and attached file, better to post
some sample data of the worksheet and what you want to do, that said and
without looking at the file sounds like you need to use a Absolute reference
, have a look in help, About cell and range references

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"- Bobb -" <nospam87@netscape.net> wrote in message
news:%23zcAg9QUFHA.3448@TK2MSFTNGP10.phx.gbl...
> Making a spreadsheet and trying to figure how to easily populate the
> formulas
> Acroos the top have columns for 10000, 20000, 30000, etc
> and down the rows have various percentages
> Each cell is merely the top column value times the percentage.
> I thought it simple until I tried to use autofill and BOTH variables
> increase - I want the column input toi stay the same.
>
> see attached for typical application that I'm trying to do.
>
>
>

[James W.]

Think this is what your after

$A$1 (absolute column and absolute row) $A$1
A$1 (relative column and absolute row) C$1
$A1 (absolute column and relative row) $A3
A1 (relative column and relative row) C3


"- Bobb -" wrote:

> Making a spreadsheet and trying to figure how to easily populate the
> formulas
> Acroos the top have columns for 10000, 20000, 30000, etc
> and down the rows have various percentages
> Each cell is merely the top column value times the percentage.
> I thought it simple until I tried to use autofill and BOTH variables
> increase - I want the column input toi stay the same.
>
> see attached for typical application that I'm trying to do