85characters
New Member
- Joined
- Jul 31, 2014
- Messages
- 5
Hi,
I’m new here and I’ve been working on a macro that’s driving me crazy. So I have three worksheets in one workbook (A,B and C). I want to merge data from four columns across worksheets A and B onto worksheet C. However, worksheets A and B do not have my four columns listed in the same order. Moreover, I want to add an additional column from only worksheet A.
So, in one workbook, it should essentially it should look like:
<tbody>
</tbody>
But I can’t figure out how to write this macro in VBA and I cannot get it. Can anyone help?
Thank you,
85characters
I’m new here and I’ve been working on a macro that’s driving me crazy. So I have three worksheets in one workbook (A,B and C). I want to merge data from four columns across worksheets A and B onto worksheet C. However, worksheets A and B do not have my four columns listed in the same order. Moreover, I want to add an additional column from only worksheet A.
So, in one workbook, it should essentially it should look like:
WORKSHEET A Column Headers -
<tbody> </tbody> | + | WORKSHEET B Column Headers -
<tbody> </tbody> | = | WORKSHEET C Column Headers -
<tbody> </tbody> |
<tbody>
</tbody>
But I can’t figure out how to write this macro in VBA and I cannot get it. Can anyone help?
Thank you,
85characters