Terminé

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

Compétences : Excel, Excel Macros, Excel VBA, Traitement de Données

en voir plus : 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

Concernant l'employeur :
( 7 commentaires ) Berlin, Germany

Nº du projet : #20226445

Décerné à:

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 3 jours
(62 Commentaires)
5.2

67 freelance font une offre moyenne de €112 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(700 Commentaires)
8.4
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(305 Commentaires)
7.3
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(221 Commentaires)
6.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(81 Commentaires)
7.0
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(87 Commentaires)
6.6
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(128 Commentaires)
6.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(149 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(75 Commentaires)
5.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(84 Commentaires)
5.9
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(150 Commentaires)
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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(117 Commentaires)
5.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(32 Commentaires)
5.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 7 jours
(19 Commentaires)
5.3
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(19 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(52 Commentaires)
5.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(52 Commentaires)
5.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(54 Commentaires)
5.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(14 Commentaires)
5.2
shahinrahimi

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 inter Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(22 Commentaires)
4.3
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(27 Commentaires)
4.5