Jun 04 2021 05:48 AM
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.
Jun 04 2021 06:02 AM
SolutionI 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
Jun 04 2021 06:10 AM
Jun 04 2021 06:18 AM
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"
Jun 04 2021 06:56 AM
Jun 04 2021 06:02 AM
SolutionI 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