HYPERLINK

R

rhhince

I have a hyperlink. I wish to change the number 35473 automatically
based on the count formula. The current count is 35500. With this
formula, I have to still change it manually. Thanks.

=HYPERLINK("#DATA!B35473",COUNT(B8:B50000)+7)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to open new window within document 0
SUMIF between date range 0
Section and Page numbering 0
Hyperlink fails to open on the first click 0
Excel 2010 countifs for date range 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Update a hyperlink in excel spreadsheet 5
Mass-remove hyperlinks from Publisher Document (VBA macro) 0

Top