trying to get excel to do a prompt with a function, can it be done

[Cathy]

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

 

[Ken Wright]

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.

 

[Cathy]

Hi Ken,

Sorry for confusing you. Below is a dumbing of what I have.

5.65 5.35 5.49 5.59
5.35 5.45 5.69 5.79
5.45 5.59 5.85 5.95
5.49 5.75 5.99 6.10
5.65 5.89 6.15 6.59

So let's say tomorrow someone says okay raise the rates of row 1 by .25 and
column 3 lower by .75. Well right now they are manually going in and
re-calculating every thing. I want a function/formula/prompt box to come and
say what row do you want to change and by what? I got a prompt box that is
yellow that when you highlight a row asks you to enter the amount in but I
have no where for the data entry and no knowledge of how to build this.

These rates are then linked to another sheet in the workbook. Is this going
to be a problem.

I have been researching VBA & I have looked everywhere for help and just am
not getting things to work out. I am sure this is something simple and I
certainly hope so but I just do not have the skill set to do this.

Please any help would be greatly appreciated. I will totally look like a
hero around here and being a new employee would only be icing on the cake!

Thanks!

 

[Ken Wright]

OK I got you

A few questions though:-

Lets assume that today the instruction was raise row 2 by 0.25. That would give
row 2 as

5.60 5.70 5.94 6.04

What happens tomorrow and the day after and so on - Does row 2 stay like that
till someone says they want to change it, or does it revert to the original
data?

Likewise with the Columns. Also, are the changes ever cumulative, ie Row may
change AND column may change, in which case the intersection of the Row/Column
would change twice?

Are all the changes additions/subtractions, or do you get % changes, or
multiplications/divisions etc

Are all the changes to each number be it row or column, always the same for each
element in the row/column, ie raise every number in the row by 0.25 - not raise
half by this and half by that?

Is all the data hardcoded - I think from your note it is, but just want to check
to see if it is the result of formulas at all.

 

[Cathy]

Ken,

The rates change when upper management chooses to have them go up or down by
a givien rate. It could be a week before any of the numbers change or it
could be one cell that changes daily and we publish new rate sheets. So I
will need to ablility to do that as well.

They are never cumulative that I am aware of.

The change in rate is always but a quarter of a point or a half of three
quarters or some variance of that.

"Is all the data hardcoded - I think from your note it is, but just want to
check to see if it is the result of formulas at all." I am not sure what
that means but I know that what I hope in sheet 1 cell e15 is then linked to
another sheet within the workbook.

I think I answered your questions and Ken any help you can give me is
greatly apprecaited.