Find Jobs
Hire Freelancers

Excel Macro Sheet

$30-250 USD

Suoritettu
Julkaistu lähes 3 vuotta sitten

$30-250 USD

Maksettu toimituksen yhteydessä
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,
Projektin tunnus (ID): 30154336

Tietoa projektista

43 ehdotukset
Etäprojekti
Aktiivinen 3 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
$0 USD 10 päivässä
5,0 (58 arvostelua)
6,9
6,9
43 freelancerit tarjoavat keskimäärin $123 USD tätä projektia
Käyttäjän avatar
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
$120 USD 1 päivässä
5,0 (295 arvostelua)
7,0
7,0
Käyttäjän avatar
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 1 päivässä
5,0 (133 arvostelua)
6,4
6,4
Käyttäjän avatar
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 1 päivässä
5,0 (90 arvostelua)
5,5
5,5
Käyttäjän avatar
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 1 päivässä
4,8 (47 arvostelua)
4,8
4,8
Käyttäjän avatar
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 1 päivässä
4,8 (25 arvostelua)
4,9
4,9
Käyttäjän avatar
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 1 päivässä
4,6 (26 arvostelua)
5,0
5,0
Käyttäjän avatar
✅ 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 3 päivässä
5,0 (11 arvostelua)
3,9
3,9
Käyttäjän avatar
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 3 päivässä
5,0 (5 arvostelua)
3,4
3,4
Käyttäjän avatar
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 2 päivässä
5,0 (4 arvostelua)
3,3
3,3
Käyttäjän avatar
Hi there, I'm expert with excel and Google sheet, i can build automated sheet with the filters you want in dashboard.
$278 USD 3 päivässä
5,0 (1 arvostelu)
3,0
3,0
Käyttäjän avatar
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 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 10 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 7 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED STATES lippu
Lakewood, United States
5,0
7
Maksutapa vahvistettu
Liittynyt huhtik. 20, 2021

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.