Forum Discussion
Relationship between 2-3-4.. Tables In Different sheets
I would like to connect 2 tables in different sheets but in the same file, Any change I do in the 1st table automatically changes in the 2nd table.
I have used "Existing Connections" but it worked in different files not in one file but different sheets, Actually at first it worked when I used in the same file but not for long time, it was 3-4 minutes.
What i need is the exact table in "Sheet1" is in the other sheets, with auto changes.
Thanks
I have used "Existing Connections" but it worked in different files not in one file but different sheets, Actually at first it worked when I used in the same file but not for long time, it was 3-4 minutes.
What i need is the exact table in "Sheet1" is in the other sheets, with auto changes.
Thanks
1 Reply
Perhaps you need to use any of lookup functions (e.g. XLOOKUP), without the sample the question is bit abstract.
