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.
65 фрилансеров(-а) готовы выполнить эту работу в среднем за €114
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.
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
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