I am doing some work for my husbands work (he taking all the credit) and they have requested that one Excell file be linked to another, which I have done quite easily using hyperlinks.
He has been asked if it is possible to link to a particular worksheet (tab) within that file and then a particular cell. Ive looked at Microsoft help which is pointing in the direction of "Function" which is confusing me, ive tried but cant get it to work, is there an easier way.
thanks
He has been asked if it is possible to link to a particular worksheet (tab) within that file and then a particular cell. Ive looked at Microsoft help which is pointing in the direction of "Function" which is confusing me, ive tried but cant get it to work, is there an easier way.
thanks