Relationship between 2-3-4.. Tables In Different sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2252387%22%20slang%3D%22en-US%22%3ERelationship%20between%202-3-4..%20Tables%20In%20Different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252387%22%20slang%3D%22en-US%22%3EI%20would%20like%20to%20connect%202%20tables%20in%20different%20sheets%20but%20in%20the%20same%20file%2C%20Any%20change%20I%20do%20in%20the%201st%20table%20automatically%20changes%20in%20the%202nd%20table.%3CBR%20%2F%3EI%20have%20used%20%22Existing%20Connections%22%20but%20it%20worked%20in%20different%20files%20not%20in%20one%20file%20but%20different%20sheets%2C%20Actually%20at%20first%20it%20worked%20when%20I%20used%20in%20the%20same%20file%20but%20not%20for%20long%20time%2C%20it%20was%203-4%20minutes.%3CBR%20%2F%3EWhat%20i%20need%20is%20the%20exact%20table%20in%20%22Sheet1%22%20is%20in%20the%20other%20sheets%2C%20with%20auto%20changes.%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2252387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2253126%22%20slang%3D%22en-US%22%3ERe%3A%20Relationship%20between%202-3-4..%20Tables%20In%20Different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2253126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1016327%22%20target%3D%22_blank%22%3E%40Mohamadesheen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20need%20to%20use%20any%20of%20lookup%20functions%20(e.g.%20XLOOKUP)%2C%20without%20the%20sample%20the%20question%20is%20bit%20abstract.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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
1 Reply

@Mohamadesheen 

Perhaps you need to use any of lookup functions (e.g. XLOOKUP), without the sample the question is bit abstract.