Need macro to reformat data

**s4driver** · 05-15-2013, 01:46 PM

Hittting a wall with this one. I need to script that can take the data from sheet1 and format it on sheet2. Sheet3 shows what data is desired and how it should be formatted, and sheet1 needs to remain intact. I haven't had any luck on my attempts getting it right, hoping that someone smarter than me can figure it out. thanks in advance, s4

**jaslake** · 05-15-2013, 02:22 PM

Hi s4

Do you do only one Company at a time or will there be multiple Companies? If multiple please post a sample of the Raw Data with multiple Companies.

**s4driver** · 05-15-2013, 02:35 PM

The raw data is on sheet1, there are 3 vendors in the example that I posted.

**jaslake** · 05-15-2013, 02:37 PM

Hi s4

Hah...I just opened your file on my platform and I see that. Sorry for the oversight...

**s4driver** · 05-15-2013, 02:39 PM

no prob...

**jaslake** · 05-16-2013, 01:57 PM

Hi s4

I have Code that appears to do as you require on your SAMPLE file. Chances of it working on your live Data are slim to none. The problem is, all your Customer Names in the sample file follow the same pattern (same number of characters, same breaks in the string, etc).

Please post a sample file that is representative of your actual data and I'll see if I can adapt the Code.

**s4driver** · 05-16-2013, 02:09 PM

The sample file is in the same format as the live data. I just cut a chunk out of the live to make this sample file. You could manually change the vendors to make them have different number of characters. The max is 22 characters per line for that field. thanks, s4

**jaslake** · 05-16-2013, 02:39 PM

Hi s4

Well, even in "slim to none", there's still a chance. Attached is your sample file with Code that appears to work on that file. Run the Code from the button on Sheet2.
Let me know of issues.