Lets say I have rows that show numbers 1-10. So in A1 it would be 1, cell A2 would be 2, Cell A3 would be 3 etc..etc. What I would like to do is be able to click on one of the cells and have it take you to a URL. So for example if I clicked on cell A1 it would take me to http://www.test.com/test/1, if i clicked on cell A2 it would take me to http://www.test.com/test/2 and so on. Is this possible?
I have thousands of rows so I need to be able to do this automaticall and not just manually type in each URL for each cell. Any help or suggestions are much appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.