A very simple macro to compare data between two worksheets and produce the result in a third worksheet.
Macro to be stored in the Excel Personal File.
I have a workbook that contains two sheets.
The first sheet is called "PRIMARY". This is a reference sheet. It contains item codes (in column A) their corresponding prices (Column L) tax codes (Column N).
The second sheet is called "SECONDARY". This is the sheet to be tested against the primary.
It also contains item codes (in one column B) and their corresponding prices (Column F) and tax codes (column D).
The macro should parse each item code in the SECONDARY and find its match in the PRIMARY. Once found it should:
1) compare the tax codes of the two items. If the tax code from the SECONDARY item does not match the tax code from the PRIMARY, this is a Fail case.
2) compare the prices of the two items. If the price from the SECONDARY item does not match the price form the PRIMARY, this is a fail case.
(BEWARE: In the case where the tax codes match for GST, the price in the primary is INCLUSIVE of gst and the price in the secondary is EXCLUSIVE of gst so a small mathematical operation will need to be carried out here before comparing the two prices)
3) In the case where the item code in the SECONDARY cannot be found in the PRIMARY, this is a fail case.
Results for all item codes in the secondary should be shown in a self generated worksheet called RESULT.
Hello Sir Im excel VBA macro and formula Expert :) i can do build compare macro between tax code and price in your excel file please give me this job and im able to start build now Thank you Galih
18 freelancers are bidding on average $102 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Willing to take up your project. Thank you, Regards.
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
hey. I am expert at excel. I can do it easily. how many entries are in excel file? kindly share file and message me for further discussion on this project.