Find Jobs
Hire Freelancers

Excel Automated Spreadsheet, requires array formula or makro knowledge

€30-250 EUR

Completed
Posted almost 5 years ago

€30-250 EUR

Paid on delivery
Hi, I need a spreadsheet to help fill out product data to upload to E-Commerce websites. It should work like this: I enter a few data points into a worksheet. Based on this data two other worksheets are filled out automatically. I will make a annotated version saying which value needs to go where. The formulas needed in the table will be like the following example: I input the number 199 in Row 1, Column A on Worksheet 1. That should enter a predetermined text in Row 1, Column AD on Worksheet 2. If I enter the number 299 in Row 1 Column 1 the text should change to a different predefined text. There will be a different text depending on what the first digit of the number I enter is. It is also important that I can change what the texts that are inserted based on the numbers and allways add more, so you need to make the source texts accessible and editable on a seperate worksheet. Only apply if you would know how to create a formula or macro to create this kind of operation. Please comment the word Waterloo when applying for the job to show you have read the requirements. Knowing how to use array formula is required, since they are likely needed for this task. Best wishes, Anton
Project ID: 20226445

About the project

63 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

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:
User Avatar
Hello Anton, † Waterloo † I can write you a macro that will update a worksheet based on what was entered on another worksheet. For the best efficiency, everything will be updated one time, once the worksheet where changes should appear has been activated. I will use arrays in my code to make the execution instant. I can create a helper worksheet, where you can enter the rules in cells without changing the code. Best regards, Ryszard
€50 EUR in 3 days
5.0 (65 reviews)
5.3
5.3
63 freelancers are bidding on average €114 EUR for this job
User Avatar
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
€150 EUR in 7 days
5.0 (815 reviews)
8.5
8.5
User Avatar
Hello Waterloo, 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.
€150 EUR in 3 days
5.0 (514 reviews)
8.1
8.1
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I am proficient with Microsoft Excel and macro/VBA development. I read your project descriptions carefully (word Waterloo is included here). I can write a macro to perform as a function to work as requested. Kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.
€100 EUR in 2 days
5.0 (184 reviews)
7.7
7.7
User Avatar
Waterloo Dear Anton I have built similar Excel Add-Ins before. The Add-In was to do many calculations on a second worksheet based on the data you input in the first worksheet. I can clearly understand your requirement and find no big challenge in doing it for you. Looking forward to working with you. Thanks & Regards Rinsad
€200 EUR in 7 days
5.0 (43 reviews)
7.7
7.7
User Avatar
Hi, I am a financial guru and expert in Excel/VBA/Macro with considerable experience working with Excel, especially organize and manipulate spreadsheets in a structured database and populate reports from it. I do these projects by advanced Formulas, Pivot Tables, Visual Basic Application (including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts). I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and cost acquisition. I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally, including collections, payments, inventory, and taxation.
€250 EUR in 3 days
4.9 (97 reviews)
7.5
7.5
User Avatar
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 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
€200 EUR in 5 days
5.0 (341 reviews)
7.5
7.5
User Avatar
Waterloo. Hi. Simple project. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
€30 EUR in 1 day
4.9 (293 reviews)
7.0
7.0
User Avatar
Waterloo € 30 ONLY !!! In just 30 Minutes!! [EXCEL FORMULA EXPERT] Sir, Please CONTACT me before closing the project, I can SEND you DRAFT project file to ensure my expertise. If you are 100% satisfied first, then award me the project. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
€30 EUR in 1 day
5.0 (418 reviews)
6.9
6.9
User Avatar
Hi, As per requirements I will develop automation/ VBA macro for you which will update the corresponding data on other sheets based on value entered on first sheet as per description of the project. Please share your Excel sheet. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan
€149 EUR in 4 days
5.0 (96 reviews)
6.5
6.5
User Avatar
Hi, The Battle of Waterloo was fought on Sunday, 18 June 1815 near Waterloo in Belgium, part of the United Kingdom of the Netherlands at the time. I am an Excel expert and can create formulas to perform required operations. Please take a look at my reviews and portfolio for Excel projects here: https://www.freelancer.com/u/best4best?w=f Regards Mamta
€90 EUR in 2 days
5.0 (165 reviews)
6.5
6.5
User Avatar
Hi Sir, Waterloo. I went through the requirement clearly and understood the need. I challenge to complete the job within 15mins-60mins . Please ping back with the file. I am very good in Excel/VBA having 10+ years of experience .Please check my past reviews. Thank You Regards Rishi
€50 EUR in 1 day
4.9 (165 reviews)
6.0
6.0
User Avatar
Waterloo I can do the job! I would probably go with VBA excel macros to avoid array formulas (faster than normal formulas but sheet structure gets locked, and macro when properly coded will be much faster for large data sets). I'm an engineer with advanced working knowledge and experience in Excel, VBA and VBA interaction between different software (Word, Excel, Powerpoint, Outlook, Access, Autocad, Project, etc.). Also, have lots of experience with processing very large data files in different formats with VBA (especially csv data acquisition files). I value and honor customer service so I will be available for help, small adjustments, bug fixes even long after the project has been paid for and closed.
€70 EUR in 3 days
5.0 (50 reviews)
5.6
5.6
User Avatar
Hi, I can write the formulas that you described in your project post to change the text based on the number that you fill. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets) as an Industrial Engineer at Michelin Romania . I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
€100 EUR in 1 day
5.0 (23 reviews)
5.7
5.7
User Avatar
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
€250 EUR in 3 days
4.9 (119 reviews)
6.0
6.0
User Avatar
I can integrate the worksheets and automatically fill data based on product sku number or order ID or any other parameter using excel formulas and VBA macros, as i have done similar work for other eCommerce merchants. I have more than 5 years of experience in advanced excel based tools, VBA automation and data processing. I have successfully completed similar projects for eCommerce merchants , please have a look at my portfolio for details. You can get your work done here with highest quality at lowest price. Looking forward to work with you
€70 EUR in 2 days
4.9 (53 reviews)
5.9
5.9
User Avatar
Waterloo Hello Sir, I would like to have this opportunity to explore my excel skills on macros and formulas. I have developed many process and automated spreadsheets as well so far. I am looking forward working with you. Kind Regards Gopal
€140 EUR in 7 days
4.2 (43 reviews)
6.9
6.9
User Avatar
Hi, good day. I don't know why but Waterloo!!, I'm interested in your project and like to participate in, we need auto macro and should create a dynamic database for text according to the digit number, if you are interested we could have chat about details. I have rich experience in excel (advanced formulas, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Python, Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} • Translating ...........................................{English, Turkish, Farsi} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin
€50 EUR in 1 day
4.6 (67 reviews)
6.1
6.1
User Avatar
Hi, there I hope all's well with you. I can code that using SQL/ADO coding within Excel. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. Please visit :https://www.freelancer.com/u/zu02?w=f Thank you for your consideration. Zura
€223 EUR in 7 days
4.8 (37 reviews)
5.9
5.9
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
€98 EUR in 3 days
4.6 (52 reviews)
5.8
5.8
User Avatar
Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks
€50 EUR in 1 day
4.9 (50 reviews)
5.1
5.1

About the client

Flag of GERMANY
Berlin, Germany
5.0
12
Payment method verified
Member since Jul 6, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.