Automatically populating information from one sheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2416125%22%20slang%3D%22en-US%22%3EAutomatically%20populating%20information%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416125%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20tabs%20where%20one%20is%20the%20Master%2C%20and%20the%20other%20is%20the%20Display.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20have%20information%20from%20Master%20E30%2C%20F30%20and%20H30%20populate%20Display%20C11%2C%20D11%20and%20E11%20respectfully.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE30%20First%20Name%3C%2FP%3E%3CP%3EF30%20Last%20Name%3C%2FP%3E%3CP%3EH30%20Position%20number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20anchor%20data%20would%20be%20Master%20H30%2C%20which%20would%20match%20Display%20E11.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThus%20any%20information%20changed%20in%20Master%20E30%20and%20F30%2C%20would%20automatically%20change%20in%20Display%20D11%20and%20E11.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20prefer%20not%20to%20change%20the%20columns.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2416125%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416161%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20populating%20information%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416161%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1071130%22%20target%3D%22_blank%22%3E%40noibad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20suspect%20you%20want%20something%20more%20than%20you%20describe.%20Based%20on%20your%20post%2C%20it%20would%20be%20very%20simple%3A%3C%2FP%3E%0A%3CP%3EIn%20C11%3A%20%3DMaster!E30%3C%2FP%3E%0A%3CP%3EIn%20D11%3A%20%3DMaster!F30%3C%2FP%3E%0A%3CP%3EIn%20E11%3A%20%3DMaster!H30%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416168%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20populating%20information%20from%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416168%22%20slang%3D%22en-US%22%3EThank%20you%20Hans.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20a%20novice%20user.%3CBR%20%2F%3E%3CBR%20%2F%3EWould%20I%20be%20able%20to%20merge%20the%20data%20of%20Master%20E30%20and%20F30%20to%20show%20in%20one%20cell%2C%20Display%2011%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20help%20did%20work.%20Just%20trying%20to%20be%20juicy%20now%20with%20the%20merge.%3C%2FLINGO-BODY%3E
New Contributor

Hello.

 

I have two tabs where one is the Master, and the other is the Display.  

 

I would like to have information from Master E30, F30 and H30 populate Display C11, D11 and E11 respectfully.  

 

E30 First Name

F30 Last Name

H30 Position number

 

The anchor data would be Master H30, which would match Display E11.  

 

Thus any information changed in Master E30 and F30, would automatically change in Display D11 and E11.

 

Would prefer not to change the columns.  

 

Please advise.

 

 

 

4 Replies

@noibad 

I suspect you want something more than you describe. Based on your post, it would be very simple:

In C11: =Master!E30

In D11: =Master!F30

In E11: =Master!H30

Thank you Hans.

I am a novice user.

Would I be able to merge the data of Master E30 and F30 to show in one cell, Display 11?

The help did work. Just trying to be juicy now with the merge.

@noibad 

For example:

 

=Master!E30&" "&Master!F30

 

if you want the full name in the form "Jane Roe", or

 

=Master!F30&", "&Master!E30

 

if you prefer "Roe, Jane"

Hans, worked like a charm.

Thank you once again.