Need help with macro for converting data

anyone have know how to convert the following source data that looks like this:

5105473, 5105474, 5105475 batch 12/21/2012 187836




where 5105473, 5105474, 5105475 is in column A, batch is in column B, 12/21/2012 is in column C and 187836 is in column D


goal is to return 3 rows and 4 columns that look like this:

5105473 batch 12/21/2012 187836
5105474 batch 12/21/2012 187836
5105475 batch 12/21/2012 187836

needs to be dynamic, values in column A can vary 2-20 values
total number of rows can also vary

thanks in advance

Here's a quick suggestion:

Please Login or Register  to view this content.

sullivan372,

Thanks for the code, I follow the logic but when I try to execute the macro it doesn't do anything. Any suggestions?

Sorry for the delayed response - The first things that come to mind are:
-You need to rename the sheets in the code to whatever yours are named
-Your first row is blank meaning the loop only executes once, on nothing

Check these things and let me know if you had already solved it. Otherwise, it would be easiest if you can post your file, so I can test it directly.

Thanks for getting back to me. I did replace the tab in the the macro and there's not a blank row first. The file I'm working with is quite large so I just included a sample section of it. Let me know if you can can get it to work.

Mike,


That code works. How can I modify to have the output on another tab so the source data remains intact?

Works perfect. Problem solved.

Thanks for all your help...

Originally Posted by s4driver

Thanks for getting back to me. I did replace the tab in the the macro and there's not a blank row first. The file I'm working with is quite large so I just included a sample section of it. Let me know if you can can get it to work.

Here's another:

Please Login or Register  to view this content.