Develop a macro to solve below problem

Here is the problem


Sheet 1 - file 1 is base datafile thats maps our master product file with master product file received from our suppliers / merchants listing supplier product code to our product code, and supplier name to our name. This is prepared basis a one time exercise.
Sheet 1 - file 2 is daily price list that we receive from the supplier in that format - it lists down supplier product code, supplier product name, MRP i.e. list price, selling price - at times this is at a discount to list price, and quantity available for sale.
Sheet 1 - file 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 file 3 to upload the file in our system that calculates final selling price to retail consumers. Our agents often refer this final file while discussing sales with potential customers.



. The problem is the output sheet is not proper . The output file should have three sheets . First sheet containing the mapped items , second sheet showing items whose list price information is not available and third sheet showing that multiple Price records found

Here is the code . Please let me know what is the problem in the code . Not able to get it .

Please Login or Register  to view this content.

I think you should upload it in a sheet with the macro in it. The code you have there seems to have some spaces missing?
Also you should change the title of the post to something more descriptive so you attract people who are interested in the issue, and so that other users can search the topic later after it is resolved as per the forum rules.