Quote Originally Posted by Carbon View Post
Yea, I figured that out in post 7. What is the absolute reference? Sorry I'm self teaching here.
The dollar sign: $. So if you want to fix A1 so it doesn't update, enter: $A$1. If you want to fix only A, enter: $A1 and vice versa