Advanced text formating with excel VBA ?

[sroyroy]

Here is the link to my mockdata:https://www.box.com/s/d2orswilu6vhgo1f0j3k
Here I have sheet1 data and what to get the data as in sheet2 format.
Data in pink i.e, "catalog number" may go upto any number of row. For understanding here are two only.

In real I have multiple sheets and want to get the formatted sheet1 data in sheet1 only, sheet2 data in sheet2 only, sheet3 data in sheet3 only.....sheet n data in sheet n.

Finally I want o get the formatted data combined in a single sheet except 1 sheet named xdetail. So there will be only two sheets.

If any filed is missing in unformatted data then let the formatted data box is blank.
I am looking for a simple VBA code so that I can easily edit it. Looking for help from experts.

 

[hiker95]

sroyroy,

I have looked at the two workbooks several times since you started the new post.

The structure of the data in both workbooks is completely different/complex, and, would require two different (complex) macros.

I am not willing to take on the tasks.

A lot of the helpers are not willing to open workbooks from sites like Box.


In your other post, try:

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