Excel Macro - Compare tax codes and prices

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.

Kemahiran: Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: compare tables using excel macro, excel macro compare table, excel macro compare tables, excel macro tutorial, how to calculate income tax in excel sheet, how to calculate income tax in excel with formulas, excel vba macro, how to code in excel, macros for excel, excel federal tax formula, tax calculator excel spreadsheet, excel macro compare rows, yahoo excel macro download historical stock prices, excel macro compare copy, excel macro compare worksheet, excel macro compare files, excel macro extract yahoo historical prices, excel macro compare text, excel macro compare text files, excel macro compare range

Tentang Majikan:
( 4 ulasan ) ERMINGTON, Australia

ID Projek: #18027961

Dianugerahkan kepada:


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

$100 AUD dalam 3 hari
(323 Ulasan)

18 pekerja bebas membida secara purata $102 untuk pekerjaan ini


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Ex Lagi

$200 AUD dalam 2 hari
(645 Ulasan)

Hello! My name is Paris. Your project's brief is very detailed, although it would be rather helpful to have your spreadsheet handy. Anyway, what yo menion about requiring data to bedisplayed in a third sheet after c Lagi

$80 AUD dalam 3 hari
(177 Ulasan)

Hello, i am serious freelancer with 100% completion rate and i believe i can help you. I've completed hundreds of excel VBA (macro) projects without a single problem. If you are interested in working with me i need a s Lagi

$83 AUD dalam 0 hari
(430 Ulasan)

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

$155 AUD dalam 3 hari
(93 Ulasan)

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed mor Lagi

$120 AUD dalam 3 hari
(164 Ulasan)

Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

$111 AUD dalam 4 hari
(51 Ulasan)

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.

$155 AUD dalam 3 hari
(66 Ulasan)

let me review the spread sheets for calculating appropriate duration and cost as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requ Lagi

$30 AUD dalam sehari
(81 Ulasan)
$388 AUD dalam 4 hari
(28 Ulasan)

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]

$60 AUD dalam sehari
(54 Ulasan)

Dear customer, this is a very simple task which I'd complete with Java on intraday. I got all the information I need, an example of the excel sheet would give me all the things I need to start developing. Please p Lagi

$66 AUD dalam sehari
(2 Ulasan)

Hi, I am an Excel Expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Thank you Awaiting your response.

$45 AUD dalam 2 hari
(34 Ulasan)

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m eff Lagi

$35 AUD dalam 3 hari
(14 Ulasan)

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.

$100 AUD dalam 2 hari
(4 Ulasan)

Hi there, i understand your requirement and if you need a sample work,can provide within one hour. if you have any questions please let me know, can start now your project according to the your guide line with Con Lagi

$50 AUD dalam sehari
(9 Ulasan)

I understood the project requirement, we need to compare the items like price, item code and tax codes. Compare both as inclusive of Tax, we need to first change the price of secondary to be inclusive of GST. I am a Lagi

$30 AUD dalam 3 hari
(0 Ulasan)

"Greetings! According to your stated project description you need an excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your Lagi

$30 AUD dalam 5 hari
(1 Ulasan)