input or copy data
Hello,
I'm would like to have the data entered into one cell be copied to
another cell so the value is = that value. I hope I can explain this:
Cell A1= 100
Cell B1=needs to be 100 or greater, but i want someone to entered a
greater number if they would like. if they try to enter a number less
than A1 then they get the value of A1 again or an error box telling
them of their mistake. I'm afraid this will require some type of basic
programming? If it requires programming where does it go? in the B1?
Thanks in advance for your help!! mitch
|