Find Jobs
Hire Freelancers

Excel Macro - Compare tax codes and prices

$30-250 AUD

Terminado
Publicado hace más de 5 años

$30-250 AUD

Pagado a la entrega
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.
ID del proyecto: 18027961

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
4,9 (323 comentarios)
7,0
7,0
18 freelancers están ofertando un promedio de $102 AUD por este trabajo
Avatar del usuario
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 Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
$200 AUD en 2 días
5,0 (645 comentarios)
8,3
8,3
Avatar del usuario
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 sample of all 3 sheets (PRIMARY and SECONDARY, as well as output format of the RESULTS generated sheet). Thanks, Milan
$83 AUD en 0 día
5,0 (430 comentarios)
6,8
6,8
Avatar del usuario
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 checking sheets PRIMARY and SECONDARY makes sense. What I deliver for you is an Excel spreadsheet filled with code. It will have an xlsb extension (.xlsb) and will run on both PCs and MACs. You'll only have to press a byutton to make the code un no matter how many rows of data you have. I'm going to spend less than 2-3 days to complete your project including required revisions for a total payment of $80 (a single milestone once you're happy with the final result). I'm a very experienced and skilled MS Excel developer as you can easily check for yourself. You're welcome to visit my personal page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$80 AUD en 3 días
4,9 (177 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
4,9 (93 comentarios)
6,6
6,6
Avatar del usuario
"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 more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
$120 AUD en 3 días
4,9 (164 comentarios)
6,5
6,5
Avatar del usuario
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 en 4 días
5,0 (51 comentarios)
6,1
6,1
Avatar del usuario
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 en 3 días
5,0 (66 comentarios)
5,7
5,7
Avatar del usuario
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 provide this excel file. Feel free to contact me joining the chat. Best regards Jörn Dyherrn from Germany
$66 AUD en 1 día
5,0 (2 comentarios)
3,7
3,7
Avatar del usuario
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 en 2 días
4,4 (34 comentarios)
4,1
4,1
Avatar del usuario
"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 efficient and experienced data entry worker. If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project. Regards"
$35 AUD en 3 días
4,9 (14 comentarios)
3,4
3,4
Avatar del usuario
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 en 2 días
5,0 (4 comentarios)
2,8
2,8
Avatar del usuario
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 Confirmation.
$50 AUD en 1 día
4,8 (9 comentarios)
2,4
2,4
Avatar del usuario
"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 requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
$30 AUD en 5 días
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
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 Chartered accountant and practicing as Tax and finance Consultant. Please chat for more discussion.
$30 AUD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
ERMINGTON, Australia
5,0
4
Forma de pago verificada
Miembro desde jul 4, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.