Can you try that again with some example data perhaps. I've got to admit to
being totally confused over what you are trying to achieve. No matter what it
will likely be something we can help you with, but you really need to spell it
out clearly and give us some example data. Given how long you've spent on it,
a few more minutes trying to make it easier for us to understand shouldn't go
amiss.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Cathy" wrote in message
...
I am trying to have a prompt that comes out that allows users to change a row
of numbers but a percentage that they want or a colum. Meaning right now I
have e-k with rates in it. They want to be able to change the rates without
having to go in on a daily basis and calcuate each rate seperately and then
enter that new rate on the sheet. They want to be prompted to say this row
change by +/- a given percentage. I can not figure out how to get excel to
do this.
I have working on this for days and have come up with no easy solution at
all.
Please help me!
Cathy
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/2004