Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto hyperlink between sheets by same number - maybe macro?
I am working on a report that has two worksheets. The two worksheets often
share a common number per line and I am working on linking the second sheet to the first sheet by this common number. I have been manually adding the hyperlinks, but each month the number of lines grows and it takes me longer and longer to enter the hyperlinks. I am needing a macro or some way to have excel automatically link those numbers in sheet two with the ones that match in sheet one to save me lots of time (and possible errors). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to add an auto serial number column | Excel Discussion (Misc queries) | |||
Can a macro - auto populate sheets... | Excel Discussion (Misc queries) | |||
auto hyperlink between many sheets? | Excel Discussion (Misc queries) | |||
Auto number / macro creation | Excel Discussion (Misc queries) | |||
Using a macro over a number of sheets | Excel Programming |