I have two worksheets' data. Worksheet Tags. Worksheet Records.
Only Worksheet Tags has data in col P.
Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col A.
With matching data in col A, whatever I can do to copy Worksheet Tags' data in col P, inserting it
to Worksheet Records' col P (on same row where matching A col data lives), is what I need.
Changes need to happen only in Worksheet Records.
To illustrate, NOW:-----------------------------------
Worksheet Tags
<tbody>
</tbody>
<tbody>
</tbody>
Worksheet Records
<tbody>
</tbody>LATER:-------------------------------------------------------------
Worksheet Records, with Worksheet Tags' col P data, only on rows where their col data matches.
<tbody>
</tbody>
<tbody>
</tbody>
Thank you so much in advance!!
Only Worksheet Tags has data in col P.
Worksheet Tags has only SOME of the same data in col A that Worksheet Records has in col A.
With matching data in col A, whatever I can do to copy Worksheet Tags' data in col P, inserting it
to Worksheet Records' col P (on same row where matching A col data lives), is what I need.
Changes need to happen only in Worksheet Records.
To illustrate, NOW:-----------------------------------
Worksheet Tags
A | P | C | |
---|---|---|---|
1 | 12345 | T, R, F, G, V | |
2 | 67890 | R, T, Y, U, | |
3 | 55432 | T, R, F, G, V | |
4 | |||
5 |
<tbody>
</tbody>
Sheet: Sheet3 |
<tbody>
</tbody>
Worksheet Records
A | P | C | |
---|---|---|---|
1 | 55432 | ||
2 | 12345 | ||
3 | 55432 | ||
4 | 23456 | ||
5 | 45456 |
<tbody>
</tbody>
Worksheet Records, with Worksheet Tags' col P data, only on rows where their col data matches.
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]A[/COLOR] | [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]P[/COLOR] | [COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]C[/COLOR] | |
---|---|---|---|
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]1[/COLOR] | 55432 | A, B, C, D, E | |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]2[/COLOR] | 67890 | R, T, Y, U, | |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]3[/COLOR] | 12345 | A, B, C, D, E | |
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]4[/COLOR] | 23456 | ||
[COLOR=[URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF"]#FFFFFF[/URL] ]5[/COLOR] | 45456 |
<tbody>
</tbody>
Sheet: Sheet3 |
<tbody>
</tbody>
Thank you so much in advance!!
Last edited: