Завершен

Excel Automated Spreadsheet, requires array formula or makro knowledge

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

Навыки: Excel, Excel Macros, Excel VBA, Обработка данных

Показать больше: excel automated graphs, excel stock spreadsheet, advanced excel mortgage spreadsheet, excel automated graph, soccer excel blank spreadsheet league, port excel vba spreadsheet website, eplain excel budget spreadsheet stock symbols, rent excel scenario spreadsheet, excel turn spreadsheet macro, excel webmaster spreadsheet calculate hosting, can combine contents excel spreadsheets spreadsheet, excel automated project visual basic mechanical engineering, open excel without spreadsheet owc11, excel filling spreadsheet data macro, excel automated project, excel escrow spreadsheet

О работодателе:
( 9 отзыв(-а, -ов) ) Berlin, Germany

ID проекта: #20226445

Поручен:

Taisho

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 cha Больше

€50 EUR за 3 дней(-я)
(65 отзывов(-а))
5.3

65 фрилансеров(-а) готовы выполнить эту работу в среднем за €114

jaylancer43

Waterloo Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer co Больше

€222 EUR за 3 дней(-я)
(721 отзывов(-а))
8.5
P0L

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 за 3 дней(-я)
(318 отзывов(-а))
7.3
dgled

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 Больше

€250 EUR за 3 дней(-я)
(84 отзывов(-а))
7.1
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 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Больше

€200 EUR за 5 дней(-я)
(230 отзывов(-а))
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Больше

€155 EUR за 3 дней(-я)
(95 отзывов(-а))
6.7
asadkhan3533

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 за 7 дней(-я)
(150 отзывов(-а))
6.5
best4best

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 oper Больше

€90 EUR за 2 дней(-я)
(151 отзывов(-а))
6.4
TechnoGuruu

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 Больше

€149 EUR за 4 дней(-я)
(79 отзывов(-а))
6.0
sloker18

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 Waterl Больше

€100 EUR за 2 дней(-я)
(92 отзывов(-а))
6.0
rengrish

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 e Больше

€50 EUR за 1 день
(152 отзывов(-а))
6.0
aubrey03

Waterloo I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Больше

€100 EUR за 2 дней(-я)
(129 отзывов(-а))
6.0
rinsadsl

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 requireme Больше

€200 EUR за 7 дней(-я)
(32 отзывов(-а))
5.5
sajidkhan45

Hi, I am an excel VBA wiz and can do pretty much anything in excel. I went through your project details and would like to have a look at your excel file. Please have a look at one of my reviews for a client called Vit Больше

€80 EUR за 2 дней(-я)
(57 отзывов(-а))
5.6
afenache

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 Больше

€100 EUR за 1 день
(20 отзывов(-а))
5.2
sonarkaushik

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 за 3 дней(-я)
(52 отзывов(-а))
5.7
vsprybhanu

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, Radi Больше

€250 EUR за 3 дней(-я)
(61 отзывов(-а))
5.3
whitehorsetechn

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. Pl Больше

€150 EUR за 2 дней(-я)
(14 отзывов(-а))
5.2
zu02

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 proj Больше

€223 EUR за 7 дней(-я)
(19 отзывов(-а))
5.4
bhupendrayadav

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. Больше

€70 EUR за 2 дней(-я)
(35 отзывов(-а))
5.2
Mickelson

Hi, sir I have just read your description carefully. As an experienced developer, I am sure that I can handle your project perfectly. Even If you don't hire me, I can give you my opinion related to this job. Let me kno Больше

€150 EUR за 2 дней(-я)
(11 отзывов(-а))
5.0