Export Model Numbers and Prices

[Torm3nt]

First off, let me preface this with saying I am no VB expert,


I work for a company that routinely gets massive excel price lists, maybe 7000 lines etc. (maybe thats not massive to you, but it is to me).


I'd like to find a way to parse the columns that contain the model number and prices. and then batch them into our Shopping Cart/CMS. I can handle the batch part but im curious if there's a way to export these columns and then set each model number and price to a variable.

I'm not asking someone to write this for me, just maybe a few lines of here start with this.

Alittle Background:
Column A is our Model Numbers
Column G is our Bulk Price
Column H is our Price Each.


If you choose to respond with some code, could you take the time to explain it? I'm trying to learn and not mooch.

Thanks,

Torm3nt

[Leith Ross]

Hello Torm3nt,

Welcome to the Forum!

A few before and after examples of what this parsed data would like would be a big help. After it is parsed where is the data going? I am not sure if it is to a file or web page.