Cell linking in Excel

[robcarr]

Hi,

I have this link on a weekly workbook

='Y:\Admin Reports\Returns productivity breakdown\July 06\[Daily Returns Productivity Report 31.07.06.xls]Summary'!E$4
[\code]

how can i get the date to be changed based on a cell value, I have been looking at the hyperlink but can not get it work and link to a specific cell.

[code]

=HYPERLINK("Y:\Admin Reports\Returns productivity breakdown\" & TEXT('Reporting Data'!B1,"mmmm yy") &"\Daily Returns Productivity Report " & TEXT('Reporting Data'!B1,"dd.mm.yy")&".xls")
[\code]

everytime i try to add a sheet name the formula errors



[COLOR=red][b][i][u]Hope this is of use, Rob.[/u][/i][/b][/color][yoda]

 

[GlennUK]

You first link looks like a data link. Are you sure you want a HYPERLINK instead?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[robcarr]

looking at the hyperlink I thought it could link directly to a cell, but can a data link be setup in such a way, so it updates the link based on a date in a cell.

Hope this is of use, Rob.

 

[xlbo]

Look at the INDIRECT function

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[GlennUK]

Geoff's hint will work only on external books that are open at the same time. To have something similar working on closed books you'll have to use INDIRECT.EXT, from the Morefunc add-in, downloaded from here:

http://xcell05.free.fr/

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.