Hyperlink fill series issue
I have multiple product ledgers on a worksheet, I want an auto hyperlink created at the top of sheet when a new product ledger is included at the bottom. I have tried a couple of hyperlink functions merged with address and indirect function but didn't get the desired result. It didn't get a proper series fill in between the rows. I have to correct each row myself. Can anyone figure it out for me? Thanks in advance...
Pls attach your file!Originally Posted by stillyours786
OH, I thought that won't be necessary... Please find the attached file...
Formula:
Please Login or Register to view this content.
Ctrl + Shift + Enter!
It worked dear, but it is taking too much time calculating. It stucks on every scroll up or down. Should I decrease number of rows in the function? And also guide me what function must be put in to the balances of these ledgers so they can be dragged down too. One more thing that if I add multiple rows at the bottom of hyperlinks function and drag it down it fill in the last product ledger title till the end. Is it possible that it doesn't show like that. Thanks alot for the help.
Last edited by stillyours786; 11-14-2016 at 01:49 PM.
Hi
Try this (without a help column) in B3 and copy down
Formula:Please Login or Register to view this content.
or try
in a new column (eg. Q3) use
Formula:Please Login or Register to view this content.
and in B3 you can use
Formula:Please Login or Register to view this content.
Thanks a lot buddy, that worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks