Have to add more rows bases in a column content

Ho all.
I am new here and I have no visualbasic experience at all. I am using excel 2000 and I have a lot of records (like 5000) having this stricture:

codenumber1 | key1,key2,key3,key4,...,keyn
codenumber2 | ke1,ke2,k3,...,k3n

I need to split those records in some like

codenumber1 | key1
codenumber1 | key2
...
codenumber1 | keyn
codenumber2 | ke1
codenumber2 | ke2
...
codenumber2 | ken


I am not sure is this is possible or not or how to do this. I guess some programming is needed but I really don't know how to start

Any help is really appreciated,

Regards and thanks for your time

Welcome to the Forum.

Are a codenumber and its matching keys all in the same cell.

Is key1,key2,...,keyn a string in one cell or different entrys in different cells?

try

Please Login or Register  to view this content.

Originally Posted by mikerickson

Welcome to the Forum.

Are a codenumber and its matching keys all in the same cell.

Is key1,key2,...,keyn a string in one cell or different entrys in different cells?

Actually no. " cell,s the codenumber in one and the keyn in other comma separeted.

Thanks for the welcome.

Originally Posted by jindon

try

Please Login or Register  to view this content.

Will try but (sorry to ask) How to call it?

Thanks for your help

Will try but (sorry to ask) How to call it?

1) hit Alt + F11
2) go to [Insert] - [Module], paste the code onto the right pane
3) hit Alt + F11 to get back to Excel
4) hit Alt + F8, select "test" then hit "Run"

jindon

Thank you very much. worked perfect.

Best regards