change data from now and not from the begining

shlomop

New Member
Joined
Feb 9, 2004
Messages
4
Thank you for yesterday’s help especially for Dan, I used your formula in the validation.
Now, one more question.
I have the amount per hour on (let say) sheet 1, and it comes over to (let say) sheet 2 with the formula sheet1!b$2. Now. How can I make that if I change in sheet 1 the amount it should change it only from now on and not from the beginning? [If possible with out a macro]
[/u]
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

SIXTH SENSE

Well-known Member
Joined
Oct 29, 2003
Messages
1,883
Hi!
I guess you need a log of rates with its date of validation.example from Jan 1 2004 to Feb 1 , 2004 your rate is $25.00/hr. Then on the next line you have
Feb 2, 2004 to Blank( unitl at present) $30.00/hr.
Because the previous values will be lost if you do not save it or unless you got to type it exactly and lost the formula.
We can make a formula select the correct rate base on the
dates where they are valid.
 

shlomop

New Member
Joined
Feb 9, 2004
Messages
4
SIXTH SENSE said:
Hi!
I guess you need a log of rates with its date of validation.example from Jan 1 2004 to Feb 1 , 2004 your rate is $25.00/hr. Then on the next line you have
Feb 2, 2004 to Blank( unitl at present) $30.00/hr.
Because the previous values will be lost if you do not save it or unless you got to type it exactly and lost the formula.
We can make a formula select the correct rate base on the
dates where they are valid.

Thanks for responding.
But I don’t understand your answer, if possible please give me more details

Thanks again
 

Watch MrExcel Video

Forum statistics

Threads
1,127,073
Messages
5,622,527
Members
415,905
Latest member
8765309

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top