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