I have a large spreadsheet that tracks sales and converts currencies for global markets. I'd like to require that entry in a particular column be set up so that a person must enter a formula in that column. I receive reports from a couple dozen people and I combine them into one master spreadsheet.
Here is a specific example of what I'd like to see entered:
(To take a part that costs $1.50 and use the Mexican Exchange rate which I have in cell E4)
=1.50*$E$4
or
(To take a part that costs $2.86 and use the Euro Exchange rate which I have in cell F4)
=2.86*$F$4
Is there a way I can require (perhaps through data validation?) that every one who tries to make an entry in this particular column is required to enter data which begins with the equal sign and includes two $ signs? The exchange rates are listed across the top all in one row (row 4) and I don't want the formulas changing when I paste them into the master document so I use the $ signs.
I'm having trouble trying to figure out how to make this work. Can anyone please help me?
Thank you so much!
Here is a specific example of what I'd like to see entered:
(To take a part that costs $1.50 and use the Mexican Exchange rate which I have in cell E4)
=1.50*$E$4
or
(To take a part that costs $2.86 and use the Euro Exchange rate which I have in cell F4)
=2.86*$F$4
Is there a way I can require (perhaps through data validation?) that every one who tries to make an entry in this particular column is required to enter data which begins with the equal sign and includes two $ signs? The exchange rates are listed across the top all in one row (row 4) and I don't want the formulas changing when I paste them into the master document so I use the $ signs.
I'm having trouble trying to figure out how to make this work. Can anyone please help me?
Thank you so much!