I've got a list of weeks in cell A2 down, I want to click a button and go to a row which is within an =Address formula in A1
HELP!!!
I've got a list of weeks in cell A2 down, I want to click a button and go to a row which is within an =Address formula in A1
HELP!!!
Why don't you have a HYPERLINK function formula instead of an Address formula?
Thanks, but I can't get that to work, how would you suggest I do that?
What is your formula in A1?
=address(B1,4)
B1 has the formula =Today() to give todays date
=address(B1,4)
B1 has the formula =Today() to give todays date
So, cell A1 has the result $D$45136 ? And, if that is the case, you want to go to row 45146? Your requirement does not make sense. If you have a date in B1, and you want to go to the row for that date, I would have thought (in A1) a formula of =HYPERLINK("#A"&IFNA(MATCH(B1,A2:A9999,0)+1,1),"goto row "&IFNA(MATCH(B1,A2:A9999,0)+1,1)) would do it (assuming I guessed what is required correctly).
Perfect, thanks so much that works perfectly once I put the date in like you said.
Don’t have an account yet? Register yourself now and be a part of our community!