Automatically copying hyperlinks across worksheets

[Meatbox]

Hello,

I've got a workbook that's being used as a calendar. The first worksheet is the "Global" calendar and contains cells populated with the hyperlink function (e.g. =HYPERLINK("www.event.com","event"), which show when an event is taking place and link to another location with more detail on said event. All of the other worksheets are calendars for individual countries which need to be automatically populated in the corresponding cells with anything that's input into the "Global" worksheet.

Currently, the individual country worksheets use the formula =IF(Global!a1=0,"",Global!a1) to copy the information across but this only copies the text. What I really require is for the hyperlinks contained within the Global worksheet cells to also be copied across.

Can anyone recommend the best way of achieving this? I've gotten nowhere so far.

Thanks

[playaller]

You'll need a Function for this placed in a module of the workbook converting the dates.

Create a new module or place the code below in the top of an existing module of the workbook:

Please Login or Register  to view this content.

Replace your formula:

Please Login or Register  to view this content.

With this one:

Please Login or Register  to view this content.

I've attached an example below:

[Meatbox]

Awesome Playaller, it worked perfectly,

Thanks!

[Meatbox]

Apologies, it's not working quite as well I initially thought. It seems to work when the original cell is formatted like your example with a simple hyperlink ([email protected]). Unfortunately my cells in the Global sheet are in the format: =hyperlink("[email protected]","tom"). When I do as you suggested with the cells like these in the global sheet, the corresponding cells in the other sheets give a value error. I need the corresponding cells in the other sheets to display and behave exactly like those in the global sheet, i.e show "tom" with the "[email protected]" link behind them. Any ideas where I might be going wrong?

Thanks

[Meatbox]

Bump - I'm under a bit of pressure to get this sorted!

[Meatbox]

Bump #2 - I'd really appreciate if someone could help me out here