Converting a date in Excel & sorting hyperlinks

jackomdj

I have something similar ish I think.

I use a drop down list, which when you select it has an embedded macro which does something - in your case goes to the relevant page. In my case it sorts a separate tab by the owner and hides stuff depending upon that persons department. But I would imagine it would work for you.

laurel7172

Any reason why you can't just copy and paste A4 to D6 into F a column at a time (so they repeat the hyperlinks and go directly to the page)?

VoucherMan

laurel7172 wrote: »

Any reason why you can't just copy and paste A4 to D6 into F a column at a time (so they repeat the hyperlinks and go directly to the page)?

Opposite way round as I'd be copying from F and pasting into the various columns.
Certainly better than any ideas I've had. Thanks.

But I'm hoping for a way that's easier to execute.

EchoLocation

VoucherMan wrote: »

If this makes sense any anyone can knows a method to sort the list while keeping the correct likes i'll welcome suggestions.

I'm sure I can help with this if I understand it correctly.

If you don't want to scroll down a list, why not have a table (which you can hide) of link names alongside their target locations.
Then create a dropdown list from the names and use a HYPERLINK function to lookup the target location to create a link.
You can then select a name and the hyperlink will always be correct... (the red formula here shows whats in the ''GO' cell)

VoucherMan

EchoLocation wrote: »

If you don't want to scroll down a list, why not have a table (which you can hide) of link names alongside their target locations.
Then create a dropdown list

Pure laziness! With maybe some lack of experience using tables. As with any table or (drop down) list I would expect to press a button to access the list, then another to select the required link. more if I have to scroll through a large list.

I've actually used the method suggested by laurel7172 for now. After naming the blocks of data I wanted to copy I've managed to copy them all to where I wanted them (and sorted into order) in a couple of minutes.

Another drop down option that I hadn't thought of (realised while using the Name Box to get the lists to copy). All the names (G1:P1 in my earlier example) have been assigned a range name so can also be selected using the drop down Name Box.
I still prefer having them all on screen for a simple one click.

As for adding new names and re-sorting them into order I remembered Excel's built in macro recorder. I used to use it but then completely forgot about it. One click and the list is done. The one disadvantage for me is it makes the workbook less portable as use of macros is not always possible on other machines. Especially at work where everything is blocked.


Thanks for the suggestion though.

EchoLocation

Be efficient, not lazy!

VoucherMan

EchoLocation wrote: »

Be efficient, not lazy!

I'm trying. That's why I prefer one mouse click instead of two