Separating numbers in a cell

Closed
hotbox - Dec 19, 2008 at 01:23 AM
roserose1 Posts 10 Registration date Wednesday November 12, 2008 Status Member Last seen May 18, 2009 - Dec 19, 2008 at 02:57 AM
Hello,
I want to know how to use macro in my report,
in sheet 2 cell a2 b2
63 45,76,22,48

how can i come up an output that when i click sheet 1 the output must look like this:

a2 b2
63 45
63 76
63 22
63 48

1 response

roserose1 Posts 10 Registration date Wednesday November 12, 2008 Status Member Last seen May 18, 2009
Dec 19, 2008 at 02:57 AM
hi
this is a link where you can learn more about how to use macros in your works:
http://office.microsoft.com/en-us/excel/HA011189581033.aspx
0