How to Link Excel Data across Multiple Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1576071%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Link%20Excel%20Data%20across%20Multiple%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753710%22%20target%3D%22_blank%22%3E%40jaypee1650%3C%2FA%3E%26nbsp%3BMost%20likely%2C%20VLOOKUP%20is%20the%20function%20you%20need%20to%20look%20into.%20However%2C%20without%20seeing%20an%20example%20of%20how%20you%20have%20structured%20your%20data%2C%20it's%20difficult%20to%20explain%20how%20exactly%20it%20can%20be%20used.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575866%22%20slang%3D%22en-US%22%3EHow%20to%20Link%20Excel%20Data%20across%20Multiple%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575866%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20an%20Excel%20file%2C%20I'm%20writing%20my%20emails%20and%20passwords.%3C%2FP%3E%3CP%3EIn%20the%20first%20sheet%2C%20there%20are%20all%20the%20emails%20that%20I%20have%20with%20their%20passwords%20respectively%20on%20each%20row.%20Each%20row%20of%20them%20has%20an%20ID.%3C%2FP%3E%3CP%3EIn%20the%20second%20sheet%2C%20there%20are%20all%20the%20websites%20that%20I%20have%20registered%20an%20account%20with.%20Also%2C%20each%20website%20has%20an%20ID.%3C%2FP%3E%3CP%3EIn%20the%20third%20sheet%2C%20I%20put%20the%20ID%20of%20the%20email%20from%20the%20first%20sheet%2C%20its%20corresponding%20website%20ID%2C%20and%20some%20info%20in%20an%20additional%20column.%3C%2FP%3E%3CP%3EAll%20of%20these%20are%20added%20manually.%20Nothing%20is%20automated.%3C%2FP%3E%3CP%3EWhen%20I%20register%20a%20new%20email%2C%20I%20will%20surely%20add%20it%20to%20the%20end%20of%20the%20first%20sheet.%20Then%20I%20have%20to%20sort%20the%20emails%20column%20from%20A%20to%20Z.%20This%20action%20disorders%20the%20IDs%20of%20the%20rows.%20That's%20why%20I%20have%20to%20re-order%20the%20numbers%20from%20the%20smallest%20to%20the%20largest.%20But%20by%20doing%20this%2C%20the%20IDs%20of%20the%20emails%20in%20the%20third%20sheet%20are%20changed%20and%20not%20correct.%20These%20IDs%20I've%20added%20them%20by%20pasting%20the%20address%20of%20the%20cell%20that%20contains%20the%20ID%20in%20the%20original%20sheet.%3C%2FP%3E%3CP%3ENote%3A%20I'm%20using%20Excel%202006%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1575866%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576076%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Link%20Excel%20Data%20across%20Multiple%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576076%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BI%20have%20added%20a%20sample%20Excel%20file%20that%20looks%20similar%20to%20my%20original%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

In an Excel file, I'm writing my emails and passwords.

In the first sheet, there are all the emails that I have with their passwords respectively on each row. Each row of them has an ID.

In the second sheet, there are all the websites that I have registered an account with. Also, each website has an ID.

In the third sheet, I put the ID of the email from the first sheet, its corresponding website ID, and some info in an additional column.

All of these are added manually. Nothing is automated.

When I register a new email, I will surely add it to the end of the first sheet. Then I have to sort the emails column from A to Z. This action disorders the IDs of the rows. That's why I have to re-order the numbers from the smallest to the largest. But by doing this, the IDs of the emails in the third sheet are changed and not correct. These IDs I've added them by pasting the address of the cell that contains the ID in the original sheet.

Note: I'm using Excel 2006

2 Replies
Highlighted

@jaypee1650 Most likely, VLOOKUP is the function you need to look into. However, without seeing an example of how you have structured your data, it's difficult to explain how exactly it can be used.

Highlighted

@Riny_van_Eekelen I have added a sample Excel file that looks similar to my original file.