Hi there
I am hoping for your help in creating a macro that will automate a repetitive piece of work I am doing
I have a sheet with data in column A and B, both having headers. Column A contains a name and be B has a reference to an account. Some have references to multiple accounts and are divided be a "/":
Here is an example:
Name Account
xxx xxx
yyy xxx/yyy
zzz xxx/yyy/zzz
I would like help with creating a macro that will:
A) Every time a name has multiple account references create a new line below
B) In the new line(s) fill in the name from above cell
C) Fill in one account name from the above line.
The end result based on the above inputs should look as follows:
Name Account
xxx xxx
yyy xxx
yyy yyy
zzz xxx
zzz yyy
zzz zzz
Can anyone help out with this?
If any clarification is needed please dont hesitate to reach out!
All help is highly appreciated!
I am hoping for your help in creating a macro that will automate a repetitive piece of work I am doing
I have a sheet with data in column A and B, both having headers. Column A contains a name and be B has a reference to an account. Some have references to multiple accounts and are divided be a "/":
Here is an example:
Name Account
xxx xxx
yyy xxx/yyy
zzz xxx/yyy/zzz
I would like help with creating a macro that will:
A) Every time a name has multiple account references create a new line below
B) In the new line(s) fill in the name from above cell
C) Fill in one account name from the above line.
The end result based on the above inputs should look as follows:
Name Account
xxx xxx
yyy xxx
yyy yyy
zzz xxx
zzz yyy
zzz zzz
Can anyone help out with this?
If any clarification is needed please dont hesitate to reach out!
All help is highly appreciated!