scohn80215
New Member
- Joined
- Mar 16, 2018
- Messages
- 9
Hi Everyone,
This will be my first post. I've researched this problem for hours and I can't find a solution.
I have two worksheets in the same workbook. Worksheet_A - has 20 columns and Worksheet_B - has about 50 columns. I need a macro, or preferably a index/match formula, to copy the data below each column from Worksheet_B and paste it to Worksheet_A whenever the column headers match.
So for example Worksheet_A looks like
[TABLE="width: 500"]
<tbody>[TR]
[TD]Dogs
[/TD]
[TD]Cats
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And Worksheet_B looks like
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cats
[/TD]
[TD]Birds
[/TD]
[TD]Dogs
[/TD]
[TD]Reptiles
[/TD]
[TD]Zoo Animals
[/TD]
[/TR]
[TR]
[TD]Siberian
[/TD]
[TD]Love Bird
[/TD]
[TD]Husky
[/TD]
[TD]Snake
[/TD]
[TD]Elephant
[/TD]
[/TR]
[TR]
[TD]Siamese
[/TD]
[TD]Parrot
[/TD]
[TD]Chihuahua
[/TD]
[TD]Frog
[/TD]
[TD]Hippo
[/TD]
[/TR]
</tbody>[/TABLE]
And I need a formula (or macro) that will leave Worksheet_A looking like:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Dogs
[/TD]
[TD]Cats
[/TD]
[/TR]
[TR]
[TD]Husky
[/TD]
[TD]Siberian
[/TD]
[/TR]
[TR]
[TD]Chihuahua
[/TD]
[TD]Siamese
[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet A starts at Row 5 with Column Headers; Worksheet B starts at Row 7 with Column Headers. The number of columns and length of rows in Worksheet_B can change so the formula/macro needs to be dynamic.
Thank so so so much!!
This will be my first post. I've researched this problem for hours and I can't find a solution.
I have two worksheets in the same workbook. Worksheet_A - has 20 columns and Worksheet_B - has about 50 columns. I need a macro, or preferably a index/match formula, to copy the data below each column from Worksheet_B and paste it to Worksheet_A whenever the column headers match.
So for example Worksheet_A looks like
[TABLE="width: 500"]
<tbody>[TR]
[TD]Dogs
[/TD]
[TD]Cats
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And Worksheet_B looks like
[TABLE="width: 500"]
<tbody>[TR]
[TD]Cats
[/TD]
[TD]Birds
[/TD]
[TD]Dogs
[/TD]
[TD]Reptiles
[/TD]
[TD]Zoo Animals
[/TD]
[/TR]
[TR]
[TD]Siberian
[/TD]
[TD]Love Bird
[/TD]
[TD]Husky
[/TD]
[TD]Snake
[/TD]
[TD]Elephant
[/TD]
[/TR]
[TR]
[TD]Siamese
[/TD]
[TD]Parrot
[/TD]
[TD]Chihuahua
[/TD]
[TD]Frog
[/TD]
[TD]Hippo
[/TD]
[/TR]
</tbody>[/TABLE]
And I need a formula (or macro) that will leave Worksheet_A looking like:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Dogs
[/TD]
[TD]Cats
[/TD]
[/TR]
[TR]
[TD]Husky
[/TD]
[TD]Siberian
[/TD]
[/TR]
[TR]
[TD]Chihuahua
[/TD]
[TD]Siamese
[/TD]
[/TR]
</tbody>[/TABLE]
Worksheet A starts at Row 5 with Column Headers; Worksheet B starts at Row 7 with Column Headers. The number of columns and length of rows in Worksheet_B can change so the formula/macro needs to be dynamic.
Thank so so so much!!