Question

"create link to sourse data " is used in which ms excel option.​

Answer 1

Method 2

• Start on the source information sheet and copy the information you wish to link.
• Right click on the cell in the destination sheet adn go to 'Paste special'
• Click on the 'Data link' icon. Interestingly, if you are used to opening up the paste special box, the data link option doesn't appear in it.

Answer 2

Answer:

First click in the cell in the destination worksheet you want the data to appear

Insert =

then click on the information in the source worksheet you want to carry across

hit enter

Hope it's helpful to you.