Entering data from one tab to multiple tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-1764204%22%20slang%3D%22en-US%22%3EEntering%20data%20from%20one%20tab%20to%20multiple%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764204%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20enter%20information%20into%20one%20tab%2C%20that%20will%20auto%20fill%20into%20another%20tab%20for%20multiple%20people%20and%20tabs.%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20if%20I%20enter%20a%20%22X%22%20into%20a%20column%20Example%20Photo%20E1%2C%20(L%20named%2030)%26nbsp%3B%20%26nbsp%3BI%20would%20like%20it%20to%20auto%20fill%20into%20the%20tab%20of%20their%20department%20(Photo%20E2)%20in%20the%20photo%20E3%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20do%20this%20for%20multiple%20entries%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1764204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1764339%22%20slang%3D%22de-DE%22%3ESubject%3A%20Entering%20data%20from%20one%20tab%20to%20multiple%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1764339%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826417%22%20target%3D%22_blank%22%3E%40MollieCNolan89%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20You%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Good Morning, 

I am trying to enter information into one tab, that will auto fill into another tab for multiple people and tabs. 

Example: if I enter a "X" into a column Example Photo E1, (L named 30)   I would like it to auto fill into the tab of their department (Photo E2) in the photo E3 column. 

 

is there a way to do this for multiple entries?  

2 Replies
Highlighted

@MollieCNolan89 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@MollieCNolan89 

It all these are in one cell, you may select all sheets and enter the value. Otherwise XLOOKUP or like.