sorry its not clear, i just want to change the years of service and have it
automatically change the pay rate in the other 3 columns

"comotoman" wrote:


Do you want the number to be the same in the next 3 columns as the one
you changed?

Ex. a1 =2 a2=3 a3=5 a4=7

change a2:a4 to the same as column a1 '2'

if thats the case then your formula would be a2 =a1, a3 =a1, a4 =a1

Not sure if this is what you are looking for?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=503372