Hi There
Would be grateful if someone can help develop a macro to solve below problem
* Sheet 1 is base datafile mapping our master product file with master product file received from our suppliers / merchants
* Sheet 2 is daily price list that we receive from the supplier in that format
* Sheet 3 is the format in which we need output basis mapping of sheet 1 with sheet 2. Instructions are given against each field. We use sheet 3 to upload the file in our system that calculates final selling price to retail consumers
the file formats are attached on google drive link here: https://drive.google.com/folderview?id=0B7ynWqzeAP-VRU9DdXNTTmV3dE0&usp=sharing
Many thanks for your time and help here.
Would be grateful if someone can help develop a macro to solve below problem
* Sheet 1 is base datafile mapping our master product file with master product file received from our suppliers / merchants
* Sheet 2 is daily price list that we receive from the supplier in that format
* Sheet 3 is the format in which we need output basis mapping of sheet 1 with sheet 2. Instructions are given against each field. We use sheet 3 to upload the file in our system that calculates final selling price to retail consumers
the file formats are attached on google drive link here: https://drive.google.com/folderview?id=0B7ynWqzeAP-VRU9DdXNTTmV3dE0&usp=sharing
Many thanks for your time and help here.