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
Menu
Query on links in Excel
Replies (7)
| 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 u can use function of vlookup |
" |
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.
U can use goal seek or auditing toolbar for tht
How?
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.
| 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
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.
Recent Topic
- Gift recd from brother
- How to show Loan write off in DPT 3?
- Form 10E and Salary arrear
- LTCG U/S 54F. Sale of property plus sale of share
- Issue with ITR2 online utility for HUF
- TDS deducted by EPFO under wrong section
- Schedule SI in ITR-2
- What is the easy way to do CA- through foundation
- Schedule FA query for this AY 2026-27
- Business income source for husband and wife
Related Topics
CAclubindia
