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.
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
67 freelance font une offre moyenne de €112 pour ce travail
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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