Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Query on links in Excel

Anil (1638 Points)

04 May 2009

I have one work sheet whith one list. Let us call it list A. I have some workings in another sheet. (Say B) I have linked(Given reference) of A to B. Now I would like to ensure that every thing in A is mapped/ linked to B. How to do this without checking each link which takes lot of time? Are there any shortcuts for checking this? Thanks

Reply
Follow
Share

7 Replies

Ashish (Audit) (26 Points)
Replied 04 May 2009

Originally posted by :Anil

u can use function of vlookup

Upgrade to CAclubindia Pro. Subscribe Now!

Anil (1638 Points)
Replied 04 May 2009

Thanks.

Thanks on letting me know about linking using vlookup.

In the sheets I have mentioned linking is already done. It is done without using vlookup.

I would like to know how I can check whether everything in list A is linked to sheet B

Thanks.

GaUrAv (C.A. and MOS) (574 Points)
Replied 10 May 2009

U can use goal seek or auditing toolbar for tht

Anil (1638 Points)
Replied 11 May 2009

How?

GaUrAv (C.A. and MOS) (574 Points)
Replied 24 May 2009

Follow this u will come to know about all the formulas...

Press Ctrl+` (the button above your tab key) and the worksheet shows you all the formulas you have used in that worksheet.

Your screen looks ittle weird, but will show you all the formulas in that worksheet.

TO return to nomal mode again press the same key.

Upgrade to CAclubindia Pro. Subscribe Now!

Ashwani Narnoli (.) (1843 Points)
Replied 06 August 2009

Originally posted by :Anil
"	I have one work sheet whith one list. Let us call it list A. I have some workings in another sheet. (Say B) I have linked(Given reference) of A to B. Now I would like to ensure that every thing in A is mapped/ linked to B. How to do this without checking each link which takes lot of time? Are there any shortcuts for checking this? Thanks	"

I agree with Ashish