[Solved] Macro program-split cell and paste in column

[chandrankrishnan]

Hi all, Good day.

Can any one Help me with an macro program for the attached file. I failed to get the output.

Thanks in advance.

[JohnSUN-Pensioner]

It seems to me that you looking something like this

[chandrankrishnan]

Hi john, thanks for the reply,you are correct,my idea of output is same as you mentioned.

Also kindly clarify me whether this will delete the duplicates if any.

While running the macro i am getting an error as Basic run-time error as :

"Argument is not optional" in If Not IsArray(aDPPARTNO)Then Exit Function

Please help me.

[JohnSUN-Pensioner]

Also kindly clarify me whether this will delete the duplicates if any.

Yes, duplicate removal occurs at the moment of collecting information from the original data sets.

While running the macro...

This macro is not necessary "to run". It should be in the right place at the free sheet write the formula similar to

Code: Select all

=GETUNIQUMLIST(INPUT.B3:B5;INPUT.K3:K5;INPUT.L3:L5)

where first param is range with all cells of source "DP PART NO." , second param - cells of "LOCATIONTOP" and the last param - "LOCATIONBOTTOM"
Press Ctrl+Shift+Enter and get array of result.

[chandrankrishnan]

John thanks once again,but while pasting the formula i am not getting the result(pasted as you mentioned). Kindly guide me.

Whether its not possible in macro program.

Please help me.

[JohnSUN-Pensioner]

Yes, beginners these actions somehow cause difficulties
See small instruction here

[chandrankrishnan]

Thanks john,its working fine. You are really great to be kind to teach others in simple way.

Thanks alot.

Just an doubt when the program assigned in macro button it shows error.It cannt be assigned in macro button.

Help me in this.

Thanks in advance.

[JohnSUN-Pensioner]

Of course, it can be assigned in macro button. But in describing the problem, you do not say anything about the button

[chandrankrishnan]

John thank-you very much.Its working fine.

It was very good experience and learned a new thing through this forum especially through John. He Helped me in all minor doubts and guided me in all aspects.

Thanks john.

Good day.