Find Jobs
Hire Freelancers

Urgent, require immediately. Excel VBA: Require worksheet to convert single row in table with multiple rows via lookups

$10-30 AUD

Zamknięte
Opublikowano około 5 lat temu

$10-30 AUD

Płatne przy odbiorze
We have a spreadsheet with orders in it with a row for each product (30+ columns). Some rows however have a items that represents a group. We require a VBA programming to 1) find the group item 2) look up a range (2 columns, up to 15 rows) insert the range into the table 3) Fill down some 5 column values against the inserted range to maintain data consistency. Spreadsheet will be provided as an example with all grouped items as named ranges. This needs to be completed today.
Identyfikator projektu: 19121665

Informację o projekcie

33 ofert
Zdalny projekt
Aktywny 5 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
33 freelancerzy składają oferty o średniej wysokości $27 AUD dla tej pracy
Awatar Użytkownika
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$35 AUD w 1 dzień
4,9 (325 opinii)
7,9
7,9
Awatar Użytkownika
Hello Sir Im excel VBA macro and formula Expert :) i can do make macro for doing your project like u said : 1) find the group item 2) look up a range (2 columns, up to 15 rows) insert the range into the table 3) Fill down some 5 column values against the inserted range to maintain data consistency. Thank you Sincerely Galih
$30 AUD w 0 dzień
4,9 (366 opinii)
7,2
7,2
Awatar Użytkownika
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the example Spreadsheet - I would come up with a macro as required to find the group item, look up a range and fill down column values. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$35 AUD w 1 dzień
5,0 (192 opinii)
6,8
6,8
Awatar Użytkownika
I have more than 5 years of experience in advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$20 AUD w 1 dzień
4,9 (40 opinii)
5,6
5,6
Awatar Użytkownika
Hi, I went through your project description. Would you please send me the excel file so that i can prepare a plan for executing this job? I am an excel VBA expert. Kindly go through my profile and reviews so that you can be confident about me. Hope to chat with you soon Thanks Sajid
$25 AUD w 1 dzień
4,2 (63 opinii)
5,7
5,7
Awatar Użytkownika
Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman
$30 AUD w 3 dni
5,0 (11 opinii)
3,9
3,9
Awatar Użytkownika
Hi There, I am interested to your project. I can work with simple to complex excel file. Please ping me as I am available & ready to work on it. Best Regards,
$25 AUD w 0 dzień
4,9 (26 opinii)
4,2
4,2
Awatar Użytkownika
Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. I have more than 5 years of Excel VBA experience.. I will continue to work with you after the job is complete, if you have questions or concerns. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly communication. Client satisfaction is my ultimate goal. I look forward to working on this project. I would be glad to chat with you to see how I can help. Thank you for your time and consideration. Don't hesitate to contact me if you are interested, I am sure I will not let you down. Thanks & Best Regards Monir
$15 AUD w 1 dzień
5,0 (7 opinii)
3,5
3,5
Awatar Użytkownika
Hi There, I am very much interested in doing this project. I am having a very rich experience in this field. Please give me a chance to work for you. You can check my previous project feedback/Review/Rating from clients. Please consider my bid also. Please. Thanks
$25 AUD w 0 dzień
5,0 (10 opinii)
2,4
2,4
Awatar Użytkownika
Hello, my name is Marianna. I would like to introduce myself and tell you my experience, so thank you for your time. I am currently living on Italy, so my timezone is GMT+1. However, this won't be a problem for you since I can adapt my work schedule as needed. I have experience as a data entry. Particularly, I have worked on a previous high-tech company in Argentina, copying laboratory procedures from paper into a digital database, for further consultation and use. Sometimes, I created those procedures directly from scratch into the database. I have also digitalized cards with clients' information from an hotel into a database, to be used as post-sale marketing and feedback. Lately, I have been working part-time filling content of websites and testing them. I am currently working part time for an English crowdfunding agency, during the morning (in Europe time) also in the area of data entry and data processing. So, I use the computer and many tools on a daily basis. I am also very detail-oriented. I am really interested on this position, and I can be a good fit for this job. Please, feel free to contact me back for any questions you may have. Best regards, Marianna
$20 AUD w 10 dni
5,0 (1 opinia)
2,2
2,2
Awatar Użytkownika
Hi Sir/Mdm Thanks for reviewing my application. I am well versed in VBA having used it in various financial institutions. As I am a new freelancer, I am willing to do this job at a cheap cost or even for free. Please let me know your requirements. Regards
$10 AUD w 1 dzień
5,0 (7 opinii)
1,9
1,9
Awatar Użytkownika
Hi there sir, Ive gone through your project description . do you need to get it done via formula or VBA? I can do it by both. Please come to chat for more details Thank you Faizan Younas
$35 AUD w 1 dzień
4,6 (1 opinia)
1,5
1,5
Awatar Użytkownika
!!10+ years Software Developing and Graphic Design.!! Hi, My name is Vadim and username is **Best Service**. Thanks for the invitation to bid your project. I read through the job details extremely carefully. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I am a full-stack Web/Mobile developer with 10+ years experience. Also I have an expertise in Software Architecture and Data Analysis and Processing. So far I have really accomplished many projects of so many areas and make my clients successfully. I can complete your project ahead of time and within your budget. My main goal is high quality and reasonable cost!!! You can see my several past works checking out our portfolio. If you want high quality and reasonable budget, you don’t hesitate to pick me. Looking forward from you. Thanks for your attention . Vadim **Best Service**
$30 AUD w 1 dzień
5,0 (1 opinia)
0,8
0,8
Awatar Użytkownika
Hi, My name is Sam. I think I can help you, assuming I have properly understood the problem. I have a few years of programming experience, but from the sound of it we may be able to get away with an index/match or even a vlookup function in the spreadsheet. I would like to see the spreadsheet in question to have a better idea of exactly what needs to be done. The good news is that I can do it right now if you contact me promptly. Looking forward to discussing with you. Sincerely, Sam
$25 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hello Sir, How are you? I am very interested in your project. The work done will be of industry standard and would be liked by you ... it's my promise to deliver the best. I would like you to give me a chance to showcase my talent. Kindly drop a message so we can discuss. Kind Regards.
$10 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear Sir/Madam, It's my pleasure to say that I am very interested to join your team. I am full expert in Excel, Data entry, VB script and strongly believe that fit for this position. I am unemployed and can work very hard even at weekends and holidays. I am looking to your contact and start my job as soon as possible. Regards Kian
$15 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I assured you to work with in specified time and higher accuracy. Relevant Skills and Experience I am good in excel with vba, access, foxpro, visual basic programming, database development, HTML, PHP.
$23 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear Client, I hope you are doing well! I understand you need a VBA expert to automate the process. My name is Ajay and I am good at VBA. I am relatively new here at Freelancer but I have 11+ years of similar experience working with multiple MNCs. Please review the work samples in my portfolio. With me, you get on time & accurate delivery, and timely update I would like to know more about the project. Let's discuss the requirement in detail. I am looking forward to a great association. Thank You Ajay
$25 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I, along with my 12+ years experience in Excel and VBA can prove to be a helpful resource for the task you have mentioned.
$30 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I'm working as Supply Chain admin and recently have created Excel VBA project which involved extraction of group items from single row and extraction into multiple rows linked them with relevant orders. During this project I have developed few classes which may be useful. If you would share a sample raw data spreadsheet with (desirable) 1-2 manual examples of what of what is expected on output, I will let you know if I will manege to complete task within time period you require. Thank you
$25 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
Melbourne, Australia
5,0
12
Zweryfikowana metoda płatności
Członek od sty 11, 2012

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.