Hi All,
Well I am a complete newbie on VBA and am learning on the go at the moment. I do have a "little" issue that I cannot figure out:
So I have a workbook containing quite a lot of formulas already (these are working fine) but there's one last bit I cannot seem to resolve.
The sheet is as follows (please note this is just partial data):
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Column A and G have the same value for now, column B is a concatenate of G and C. What should happen is following: Column A should reflect the account number of of the Corporate account type if the Corp Code is the same. I cannot figure out how to make this going (there are about 600 lines with multiple Corp Codes, Account Types and Account Numbers). Which is why I turn to you as you have been helpful to me creating this file so far (loving the forum!)
Please help my poor brain with this problem
Well I am a complete newbie on VBA and am learning on the go at the moment. I do have a "little" issue that I cannot figure out:
So I have a workbook containing quite a lot of formulas already (these are working fine) but there's one last bit I cannot seem to resolve.
The sheet is as follows (please note this is just partial data):
<tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Column A and G have the same value for now, column B is a concatenate of G and C. What should happen is following: Column A should reflect the account number of of the Corporate account type if the Corp Code is the same. I cannot figure out how to make this going (there are about 600 lines with multiple Corp Codes, Account Types and Account Numbers). Which is why I turn to you as you have been helpful to me creating this file so far (loving the forum!)
Please help my poor brain with this problem