Færdiggjort

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.

Detail:

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.

Evner: Databehandling, Excel, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 4 bedømmelser ) ERMINGTON, Australia

Projekt ID: #18027961

Tildelt til:

prameswara

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 in 3 dage
(323 bedømmelser)
7.0

18 freelancere byder i gennemsnit $102 på dette job

jaylancer43

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 Flere

$200 AUD in 2 dage
(645 bedømmelser)
8.3
paris2785

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 Flere

$80 AUD in 3 dage
(177 bedømmelser)
6.9
MimiFL

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 Flere

$83 AUD in 0 dage
(430 bedømmelser)
6.8
polarjin2017

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 in 3 dage
(93 bedømmelser)
6.6
Tanmoy236

"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 Flere

$120 AUD in 3 dage
(164 bedømmelser)
6.5
abugosia

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 in 4 dage
(51 bedømmelser)
6.1
periyannas

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 in 3 dage
(66 bedømmelser)
5.7
royalcalif

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 Flere

$30 AUD på 1 dag
(81 bedømmelser)
5.5
$388 AUD in 4 dage
(28 bedømmelser)
5.3
aubrey03

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 på 1 dag
(54 bedømmelser)
5.1
joerndyherrn

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 Flere

$66 AUD på 1 dag
(2 bedømmelser)
3.7
prasannjeetp

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 in 2 dage
(34 bedømmelser)
4.1
dataexplorer

"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 Flere

$35 AUD in 3 dage
(14 bedømmelser)
3.4
hinafaraz

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 in 2 dage
(4 bedømmelser)
2.8
Nicecreator

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 Flere

$50 AUD på 1 dag
(9 bedømmelser)
2.4
sau23pathak

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 Flere

$30 AUD in 3 dage
(0 bedømmelser)
0.0
webscraper24

"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 Flere

$30 AUD in 5 dage
(1 bedømmelse)
0.0