Bob, thanks for wanting to help!

I'm up for trying the VBA approach if that's what you prefer; I should be able to do a little research and figure out how to make that function work.

Though I need to show you some other products' pricing table variations & differences in text strings before you get into it; I'd hate for you to not have a complete picture of the entire process. I'll get some screenshots up later today, hopefully in the next couple hours.

As for the text file, we export it from our website program as a .csv file and open it in Excel. For the pricing table, we enter base pricing at the first of the year and then derive later-in-year price increases via simple multiplication formulas. We can convert these cells to values if that is necessary.

Thanks again, and I'll post back shortly!

John

Daymaker, you're making me just a little bit nervous. I am indeed willing to help, but how? I'm firmly against the notion of my simply writing a VBA subroutine for you. Oh, I do that sort of thing professionally, and I've no objection to doing it on that basis; but this forum isn't for that, here we tell each other how for the love of the game.

I can do that—I will—but it would be by helping you understand how to write the VBA module yourself. I don't think it would be very complicated, but you must be the one who writes it because you're the one who has to live with it afterward—explain it if necessary, fix it if the input format changes, enhance it if requested and so forth.

If that's what you meant, great! But if not, reconsider how you want to approach this, knowing that I'll explain forever but you'll have to be the one who actually puts the pieces together into a working whole.

I understand Bob. We're on the same page.

Ok, just making sure. So when you're ready, tell me: How much do you already know about VBA? Have you ever written one, even a very simple one? If so, we can just talk about the logic (and it really won't be complicated). But if not, we should start by introducing you to the, um, the "infrastructure", I suppose it could be called: how to get to the VBA editor, creating a program module and so forth.

Seems I used it once or twice from help on a similar forum; just a copy & paste. That was Excel 2003. I'm on 2010 now and took a look at the attached to where I'm now able to see the VBA through the Developer tab:

http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

That's pretty much it, sorry to say...

Here's what the table/text file/spreadsheet look like for a different product:

Pricing table from website:


Text file that I took into Excel; this time I used the '^' as a delimiter so the prices would be at end of each cell (rather than one long string all in one cell); I don't know if that helps or not:


(And you mentioned RTF; the import/export file is actually a .txt file if that matters.)

Spreadsheet of values to merge into the text file: