P
PAL
I have two worksheets with data that I need. There are more than 100 rows.
The first worksheet has many columns. Let's say:
Column A is a model number: 12332
Column B is a site number: 10
A and B are essentially unique identifiers
Column C - F is other data that I will need.
The second workshet has many columns also. Let's say:
Column A is the model number: 12332
Column B is the site number but different: 10-Jones
A and B are essentially unique identifiers, differing from the first work
sheet in that "B" is a longer version from the first worksheet (10 vs.
10-Jones).
Column C - F is other data that I will need.
How do I get C-F from the second worksheet lined up and onto the first
worksheet or vice versa C-F of the first onto the second.
The first worksheet has many columns. Let's say:
Column A is a model number: 12332
Column B is a site number: 10
A and B are essentially unique identifiers
Column C - F is other data that I will need.
The second workshet has many columns also. Let's say:
Column A is the model number: 12332
Column B is the site number but different: 10-Jones
A and B are essentially unique identifiers, differing from the first work
sheet in that "B" is a longer version from the first worksheet (10 vs.
10-Jones).
Column C - F is other data that I will need.
How do I get C-F from the second worksheet lined up and onto the first
worksheet or vice versa C-F of the first onto the second.