Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cell linking in Excel

Status
Not open for further replies.

robcarr

Programmer
Joined
May 15, 2002
Messages
633
Location
GB
Hi,

I have this link on a weekly workbook

Code:
='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]
 
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.
 
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.[yoda]
 
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
 
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:


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top