A Challenge for you Excel experts

[mljohn]

I have a large list of parts that I want to change how the data is laid out.

It was laid out by the part number and which machines went to that part number. The machines were all together in one cell.

Now I want to have each machine have it's own row.

I'll need a way to automate the process since I have so many records.

I have a link to my Box.net account that shows an example spreadsheet.

http://www.box.net/shared/cl8l0vi9qh

I hope you are up to the challenge, I sure need the help.

Thanks

Matt

 

[hiker95]

how do I make this code capture more columns beyond column "J"?

mljohn,

Screenshots will probably not work correctly.

In order to continue, and, so that I can get it right on the nest try, I would like to see your actual raw data workbook/worksheet(s). And, include worksheet Results (manually formatted by you) for the results that you are now looking for.

The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.

 

[mljohn]

All I want to know is how to adjust your code that you shared with me.

https://www.dropbox.com/s/owew4y1soqqcf94/ReorgDataV3().txt?dl=0


I want to expand the number of columns. Right now it only goes to the "J" column. I've tried to change all of the "J" to "O" for example and that did not work.

Could you help?

Thanks

Matt

 

[hiker95]

mljohn,

Your link to BOX is to the text of the old/original macro. That is not what I requested.

In order to continue, so that I can create an updated/correct macro for your new raw data, and, so that I can get it right on the next try, I would like to see your actual raw data workbook/worksheet(s). And, include worksheet Results (manually formatted by you) for the results that you are now looking for.

The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.


If you are not able to provide the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[mljohn]

I can do that if you need it but what I want is to understand in the code is where it decides the number of columns to apply the code to so that I can change it if need be.

The code is great and works. I just would like to understand this one change.

Matt

 

[hiker95]

mljohn,

In your reply # 11 you supplied your actual raw data workbook/worksheet(s).

Now, your raw data has expanded to more columns.

I need to see your new raw data in order to re-write the macro code.

If you can not provide your new raw data workbook/worksheet(s), then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[mljohn]

I don't need you to write new code, the code that you wrote is fantastic and works great except that sometimes I need more columns to the right then just A-J.

Option Explicit
Sub ReorgDataV3()
' hiker95, 03/30/2011
' A Challenge for you Excel experts


I am not at liberty to give you the "raw data" and if I did give you something I would just make something up and add more columns.

What I really want to know: Is there a range in your code that I could change to extend the function of your code more columns?

This may be showing my ignorance but I assumed that the line wR.Range("A1:J1").Value = w1.Range("A1:J1").Value could be changed to add more columns but it does not seem to work.

Is there something I could change to add more columns?

If not could you help me understand what all is involved to add more columns to the Results?

Thanks for your patience and help

Matt

 

[hiker95]

I am not at liberty to give you the "raw data"

mljohn,

In your past replies, you have supplied your actual raw data workbook/worksheet(s).

It is my preference to see the raw data that I will be working with, and, what the results should look like (manually formatted by you).

One last try.

The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.


If you are not able to provide the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[mljohn]

This frustrates me.

Last time I could, this time because of the data I'm not allowed to share.

But since the question has nothing to do with the raw data and only, Can your code be extended to more columns past the "J" column?

No it can't and here is why.

Yes it can and here is how.


I am sorry that I have not been communicating my question well enough

Matt

 

[hiker95]

mljohn,

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[mljohn]

If I did that wont people see how you would not answer my question?

sad