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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel linking worksheet tabs from another file (source)

Status
Not open for further replies.

JOSROS

Technical User
Apr 18, 2004
22
CA
Hi,

help,

any body, i have a file in ms-excel,

i want to link a master payroll with another source in another file,

the problem i have is thet for every pay period use another tab in the same workbook (source) so when i update how can select the right tab on the source file (link?

thank you


example, the first link is fine because is link to [tab], may5-may18,

when the new comes the next pay period will use the next tab with a diffrent name ej: may19 - june 3.

how can i tell excel to update from that tab now.

thanks again
 
Hi,

you could use the INDIRECT formula. The only drawback is that it'll only update if the source is open.

If I remember correctly there's an Addin called MOREFUNC you can download (for free I believe) that has an INDIRECT that works on closed workbooks as well.

Cheers,

ROel
 
thank you very much.

do you know where can i find it in english?

thanks again
 





Google?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
JOSROS,

the site where you found it in French also has it in English.

Cheers, Glenn.

Beauty is in the eye of the beerholder.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top