Excel query: linking data [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I have three workbooks. A, B and C. columns in workbook B are linked to columns in workbook A. Now i want to link one of the columns (eg col D) in workbook C to one of the columns in either workbook B (eg col C) or Workbook A (eg col C) as both contains the same data. However i prefer to link workbook C to Workbook A i,e my source workbook. In any case i am not able to do it.

I tried paste special option to link workbook C ( column D) to workbook B.( column C). But when i do it it pastes data of column D instead of column C of workbook B into column D of Workbook C

Please guide me. Thanks in advance

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Tans,

Open both workbooks.
Select a destination cell. Type in =.
Select the other workbook and select the cell you wish to link and hit enter.
Remove the dollar symbols of the formula in the destination cell and drag the formula down as far as needed.

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!