Macro for Missing Product

**mahendrakumar** · 04-11-2014, 02:27 AM

Hi,

Need some help for writing macro for the following task

I collect the Products data manually and enter it into in Product details data sheet which contain detailed information about the product( Reference sheet) and then we check the products from SAP whose data is not entered by taking SAP cut for a specific month.

For this purpose I follow the following procedure.

1. Take Products details from SAP ( Product no. name, etc ...)
2. Save data in excel format.
3. Convert data into number format.
4. Arrange data in ascending order.
5. Delete the Products from SAP product sheet with a specific starting code (e.g 800000)
6. Apply vlook from a Product details data entry sheet ( Reference sheet) to SAP Product data sheet.
7. Highlight that specific products whose data in not entered in data entry sheet.
8. Save that missing products details in different sheet.

Thanks in Advance

**RudiS** · 04-11-2014, 05:56 PM

Hi Mahendra,

Welcome to the forum

I'd be happy to assist in automating these steps, but in order to do so, I need to have a sample file that shows your data structure. Is it possible to set up a sample workbook that I can reference.
What will work well is to create a sample sheet with the data that you save in Excel format
Also in the same workbook, a sheet that simulates the Product Details reference sheet
Obviously, the data should be desensitized with dummy information

If you can upload this sample, I can help you with it.
To upload a file, click on the Go Advanced button on the bottom right, and then click on the paperclip button in the toolbars of the advanced posting window.