Hi guys,

New here and add an issue I m hoping you can help me with. Here is the
problem:

I work in the pricing Dept for a grocery store. I use excel to do all my
spreadsheet work for tasks like setting up new products that are going into
the stores, creating sale item batches, and comparing sales movements on
items. The problem is that many times vendors send me the new product info in
an excel spreadsheet but the data is never formatted in a way that I can use.
I use a program call BRDATA to handle all of the stores inventory control.

What I want to be able to do and have done up until the acutall formatting
part is this.

-Open the spreadsheet from the outside vendor (completed)
-Grab the column headers and match them up with the appropriate preset
headers that I use (completed) when working with BRDATA
-Based on which preset header the imported columns correspond to, then take
that data and format it to my needs (incomplete!!!!!!!)

I can send or post the code if you guys need it! I have a working Macro with
accompanying form that I can also take a screenshot of and post as well if
you guys show me how.

Any ideas and input would be greatly appreciated!!!

Thanks!!!