exported spreadsheet to new template

$30-250 USD

Completed

Posted

over 4 years ago

$30-250 USD

Paid on delivery

Hi, I currently export 2 files from my inventory platform. From there i run an day specific macro file on one of the files exported and then i move/copy the second one to the macro ran file. from there, i perform a vlookup to pull data points together. I'd like to set up a template that would help me take the files i export daily...move/copy them into a template and hit "run" or something to do this faster than I can. the files attached: "availableinventory" is my main meaty one. this is the one i'll drop into a day specific macro file (wednesday template provided). once i have completed the macro run, i'll move/copy the availalbeinventory into a new book and save it ("wednesday 01.29.2020"). I'll then run the vlook up from the buying guide to the new "wednesday..." to extract the daily usage summary. once i've completed this, then i'll manually add some daily stuff that has to be entered in manuall (no getting around that). That stuff comes gets entered into the mixer column. the "par" column is a fluid document that i keep local. I vlookup this into the "wednesday" file for reference.

Project ID: 23637678

About the project

19 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@urielbaray

I know your TIME is VALUABLE so, honestly, thanks for reading my proposal. I have read your project and I can do it. I will see the macros that you are using and improve them to make the full job automatized. Why to choose ME? - Your satisfaction is always my first goal. - I deliver quality on time - I take only the clients I can attend myself PERSONALLY Pleased take some minutes to visit my portfolio and see both my work and my happy client's comments. We can start a chat to discuss the details of your project.

$200 USD in 7 days

5.0

(60 reviews)

6.4

19 freelancers are bidding on average $160 USD for this job

@Eagles90

Dear Client, I am an experienced VBA and Excel professional and have served the clients throughout the globe. Please review my profile to get an insight into the quality of my services. I am the one who believes in long term relationships and thus works upto client satisfaction to have them as my clients forever after. I have reviewed your job and ready to proceed to it and will wait for your response to discuss the further details and start the project. Please see this project, i have just completed: https://www.freelancer.com/projects/excel/Inventory-Tracking-21133018/details This project was almost the same thing that you are asking for, so i am the best for for your project. Please send me a message and i am ready to discuss. Warm Regards Ali

$250 USD in 3 days

4.9

(201 reviews)

8.2

@zekovicm

Hi there As an Excel VBA/Macros expert i can get it done for you . Please feel free to initiate the chat so that we can discuss further details. Best regards, Miljan

$250 USD in 2 days

4.9

(208 reviews)

7.9

@P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$200 USD in 3 days

4.9

(454 reviews)

7.8

@elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can create a tool (xlsm file) using part of what you already have (your macro) that performs the complete task. The tool would be completely reusable every time. Contact me to discuss the details. Best regards

$200 USD in 4 days

4.9

(299 reviews)

7.2

@prameswara

Hello Sir Im excel VBA macro and formula Expert :) I can do adust and add your existing macro so you can do all in 1 click and no need manual again pleease ping me now and im free now Thank you Galih

$120 USD in 7 days

4.9

(421 reviews)

7.4

@shoguna2m

Hi there, My name is Mauricio I'm the MS Excel expert from Trascender Global Team, with 5 years of experience in developing VBA projects. I've read the details of your project and I'm highly interested in working with you to automate the process you have to do by hand, creating a template that will combine the required exiting VBA macros to just one to simplify the process, following the guidelines you mentioned in the description, adding the formula required and the naming format for each run. The final macro will be as simple as pressing a run button. Let's chat so we can talk about the details of this project. Looking forward to hearing from you.

$200 USD in 7 days

4.9

(166 reviews)

7.5

@AnowarRatul

$43 Only ------ In just 12 Hours -------- I can automate your manual work through enhancing you macro program -------- Excel VBA Macro Coding, Formula Generation and Automation process expert. ------ I can start right now, please message me to discuss more.

$43 USD in 1 day

5.0

(204 reviews)

6.1

@beltran0404

Hello, I'll be glad to assist you with your Excel project. Please contact me by chat then we could discuss further details, Luis R

$120 USD in 3 days

5.0

(164 reviews)

5.9

@webdroid

Hi there, We are a team of techocrats having 6+ years of experience in Web and Mobile developement. Taking about our expertise, we possess very good expertise in PHP, Laravel, Codeignitor, MySql, jQuery, HTML5, CSS3, Bootstrap 3 & 4. We will make your website look very nice, modern and professional. We will make the website load fast, SEO friendly and responsive to all mobile devices as well. For more reference work check our portfolio: https://www.freelancer.com/u/webdroid Why choose us: ⤷ Have a programming experience of over 6 years. ⤷ More than 95% completion rate. ⤷ 99% on-time completion. ⤷ Daily progress reports / updates. We will appreciate if you come over chat and share the website requirement with us so we can suggest a better solution, Be sure that you will get quality work and reliable communication. Faheem N...

$140 USD in 7 days

4.9

(31 reviews)

5.8

@HelpingHut

Welcome to HelpingHut, Here you can find all the solutions related to your tasks. I have huge amount of experience in the field of writing. As a writer, my aim is to generate unique content as per client’s requirements. I can deliver your work within your given deadline and budget. Please give me a chance. I PROMISE you, I will not let you down.

$30 USD in 1 day

0.0

(0 reviews)

0.0

@Sattarshar

Experience of creating macros in VBA.. as long as the format of files is consistent then this work.

$277 USD in 3 days

0.0

(0 reviews)

0.0

@gauravdirector77

I have a lots of experience and knowledge of this work because i was working with bpo kpo industry in Last 4 year

$140 USD in 7 days

0.0

(0 reviews)

0.0

@Rahulramteke264

your work will be complete in asap. I can effort more for your project to give u your work as soon as possible

$50 USD in 5 days

0.0

(0 reviews)

0.0

@Rklodhi55

Thaks

$155 USD in 3 days

0.0

(0 reviews)

0.0

@viveknain01

I can do your work . I am very hard working give me a chance . I will try my best and i want to be part of your company . Relevant Skills and Experience I am hardworking and skilled in excel and many formats . I know the basics i am telling the truth but i am a quick learner and put your work on the top . Thankyou.

$155 USD in 3 days