Need Help with Complex Macro/VBA Script for Handling Several Import Files

Hi,

I realize this may be a tall order, but I know many of y'all appreciate a challange, and I would greatly appreciate any help.

I work as an eProcurement Specialist (eCatalogs), and the business in which I work has been expanding rapidly. More rapidly than our infrastructure in this area is prepared for. So I am trying to streamline the tasks we do every day and am learning on the way. I am hoping that, due to the repetitive nature of these tasks it might be an easy fix, albiet one beyond my current skills.

That said, I am trying to make a macro workbook which:

1) Serves as a centralized database for our current information by importing export files from the various programs we use.

-The fields I hope to eventually be able to import/update are;

-Catalog Tags

-Product Information

-Customer Price Files (special case here)

-Obsolete Tags (products which have recently gone obsolete)

2) Use the imported database to "bump against" the files sent to us by our branches to see what needs to be updated.

-The files sent to us are always linked by a Master Product ID, this will be the key between the files

-The book would reference the Price Files sent to us against the Tag Sheet to see what we need to tag (in one of our programs) for that customer, check the products to see what has gone obsolete and check the products to see if we need to add and format the data to our Master Catalog (which is formatted like our Product Information).

-I currently do nearly all of this "bumping" using vLookups, and in a nearly identical way each time.

3) Update the necessary information and export files

-I would eventually want it to export 4 files. The updated Price File, a sheet containing which items must be digitally tagged, a sheet containing which items sent to us are obsolete and must be substituted for new product and a sheet of Master Product IDs which must be added to our Master Catalog.


I realize this is a tall order again, but even one step would help me a ton and might give me the key I need to write it myself. I have also found another VBA script which I use quite heavily to sort data, so I will include that here.

Please Login or Register  to view this content.

I will also include several example files (much smaller than our typical ones) showing the various formats of data it would, ideally, need to import/check against.

Any help would earn my eternal gratitude, and possibly some cookies. Digital or otherwise

Hi,

You also need to post a sheet, to show the relation between the various data xlsx files. (Key fields in each sheet for the purpose of data linking)