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 -" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>
>
>
|
Similar Threads
