Find Jobs
Hire Freelancers

Excel Macro Sheet

$30-250 USD

Dokončeno
Zveřejněno skoro před 3 roky

$30-250 USD

Zaplaceno při doručení
I have an inventory sheet that I need to be figured out. I know that outcome is needed, but I want someone to give me some better ideas on how to design and construct the sheet. Attached is the sheet with some instructions. The work is needed on the first 3 sheets, the last 4 sheets are here to provide you with the data needed. The fields to fill with formulas are highlighted in yellow. We sell on several websites, and on my sheets, A marketplace listing is called "Store SKU". Every Store SKU is mapped to an internal Item Number of our internal catalog, we do have a "MAPPING" that will tell you what is the item number for each store SKU. Basically, this is an ordering sheet, that the buyer will make a note how much to order for a "Store SKU", i need the sheet to do the following jobs: A) Import "warehouse" stock into "Working sheet" so the buyer can see if the item is available in any of our warehouses. B) Generate an order to place from the vendor - but in this order, the item number have to be unique, meaning if the item number is ordered for a few different "Store SKU"s, it should only show once on the PO sheet, with the total QTY C) Generate a "Shipment" in the shipment sheet, using the "Store SKU" or listing ID. Let me know if you can work with these, and your cost would be - If we agree, I will provide you with more detailed instructions. If you would like to give it a shot we can get into more details, so I can explain everything better. Let me know your initial thoughts. Thank You,
IČ projektu: 30154336

O projektu

43 nabídky
Vzdálený projekt
Aktivní před 3 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
$0 USD v 10 dnech
5,0 (58 recenze)
6,9
6,9
43 freelancers are bidding on average $123 USD for this job
Avatar uživatele
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
$120 USD v 1 dni
5,0 (295 recenze)
7,0
7,0
Avatar uživatele
Hey, I can give you some better ideas on how to design and construct the sheet What is your Deadline?? Let's Talk upon your project Waiting for your response!!
$30 USD v 1 dni
5,0 (133 recenze)
6,4
6,4
Avatar uživatele
Dear Employers, I can assist you in “Excel Macro Sheet” the best way & according to your project need. I am an expert and professional in MS Excel Formulas & VBA (Automation by macros). Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet, User forms, Shapes variation etc. I have also handled various Excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, it includes extracting information from text files, websites, transferring info in to excel, Data analysis etc. For more info. You can see my profile before awarding me your project. https://www.freelancer.com/u/yadavexpert53 Thanks and Regards, Mohit
$70 USD v 1 dni
5,0 (90 recenze)
5,5
5,5
Avatar uživatele
Hi there, I have fully reviewed your work details and am ready to work on it. I will create an excel sheet that will constantly update the inventory from warehouse's to excels. Then the sheet will make and fulfill an order. In this regard, my budget for this work is $60 and I will complete the work in one day. Please contact me for more information. Thanks.
$60 USD v 1 dni
4,8 (47 recenze)
4,8
4,8
Avatar uživatele
Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Processing. I am the best suitable candidate to serve you. If you hire me, I will provide you good result. Let's discuss details about your job in chat. Thanks, Good luck.
$50 USD v 1 dni
4,8 (25 recenze)
4,9
4,9
Avatar uživatele
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start right away and complete it within a few hours. If interested, we can discuss this further on chat.
$80 USD v 1 dni
4,6 (26 recenze)
5,0
5,0
Avatar uživatele
✅ QUALITY FIRST Hi there, I have read your description and I can do exactly what you are looking for. I have checked your required job A, B and C. I have been working as reporting engineer and used to handle big excel files with complicated calculations. So this the job in which I am strong at. I can ensure you a quality job will be done. You can see my work quality in my portfolio. Please leave a message for further discussion. Eagerly waiting for your reply. Thanks, Abdullah
$65 USD v 3 dnech
5,0 (11 recenze)
3,9
3,9
Avatar uživatele
I am a business and administration graduated and computer science engineer. I am a certified in Excel and I am very experienced to do your project. I Will use macros and VBA design without problem. I am very imaginative and I can give you the good idea. Just tell me by chat. thanks for reading
$89 USD v 3 dnech
5,0 (5 recenze)
3,4
3,4
Avatar uživatele
Hi, I am Sucipto Angdika From Indonesia. I've finished your file. I can send to you if you're interested. I am working with named range table so no macro needed. Its formula can auto expand too. So, I convert all your regular table to named range table. And I can make you an variable input if you wish like from another store and so on. And by replace this data with another set of raw data you could make it file analyze itself. Thank you.
$250 USD v 2 dnech
5,0 (4 recenze)
3,3
3,3
Avatar uživatele
Hi there, I'm expert with excel and Google sheet, i can build automated sheet with the filters you want in dashboard.
$278 USD v 3 dnech
5,0 (1 recenze)
3,0
3,0
Avatar uživatele
I can do it I am completely engaged with this type of work I spend lot of time in it I am interested to do
$140 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Roadblock on a project with the deadline fastly approaching? Need to deliver a quality work with a professional appearance?I can solve any problem and make life easier! 100% Satisfaction Guaranteed! I look forward to working with you!
$140 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Gi I am exlert in it. Contract me directly by getting some good ideas regarding this sheet. wait for your reply. Regards Asia
$30 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
hello sir, I am a professional data entry operator or excel master I am perfect for this position I have 2 years of experience for working as a freelancer
$30 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am experienced excel VBA writer. I will do this work for you. Client satisfaction is my motto so I will provide you unlimited number of reviews until you are satisfied with my work. I am highlighting some of my previous works for your consideration + Generate price based SKU from multiple excel files and multiple sheets and converge them in one file with listing them in ascending order by price + Take Sales Receipt excel sheet as input and generate three new excel sheets each having different formats for three different sources for a client selling on different platforms online + Look for specific data in whole sheet and copy paste required data in output sheet keeping data in order If you are interested then please contact me and I will show you my previous work and we can discuss your project more Thanks
$35 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello dear i have read your project and i have understood your project .i have the experience to do this pf project earning .i have worked many platform before . So i have the confidence to do this . If you want we can work together . I have the experience to work in data entry excel . I did this kind of work before . So please let me know if you want to work with me .
$45 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I can generally compile up to 10 pages of notes per day. I'm interested to hear more about the project and about the subject matter of the lectures. If you award me the project I'd be very happy to discuss this further and get started for you as soon as possible. Thanks
$89 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
hello, i have gone through the instructions attached . i can confidently assure you that i can comfortably handle this to perfection. kindly assign me this task. thanks
$170 USD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I read job description and I can do your project. I can even work on urgent basis and complete your project soon..contact me for more information
$90 USD v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
hi sir\ ma'am i am a freelancer and i can do your project . if you give me the project so i can delivery the project to fasr.
$140 USD v 7 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
Lakewood, United States
5,0
7
Ověřená platební metoda
Členem od dub 20, 2021

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.