Excel Data Entry - Find & Replace - Create Files
$30-250 USD
Paid on delivery
DataEntry Find & Replace Jobs
You must create more or less 1100 excel files using the supplied TEMPLATE files.
In the "Inventory [login to view URL]" file, in the column B NAME OF TEMPLATE FILE TO USE, it is written what is the template to use to create the file.
In the "[login to view URL] Inventory" file, in yellow, A, D, F, G, H,. I columns highlight the values that are to be replaced within the files.
File names should return the XXX Code of column A of the "Inventory [login to view URL]" file.
In addition to this, fill out the "Inventory 1001-2000" file as an example in the first lines with YYY 1054 1055 1056 with the progressive numbering in XXX column D. So add the 2 Rows for each YYY code in Column C Compo, Poster
For each code there is a row in column C "poster" and column E “mockup ancora da fare” to be included in the "inventory [login to view URL]" file but no files need to be created from templates only in "inventory [login to view URL]" file you have to write a rows for each code.
Beware the values in column A YYY are not always progressive, sometimes values are skipped, for example, values from 1201 to 1210 do not exist.
Caution, as a reference from the "Inventory 1001-2000" file, some codes have the column G DESCRIZIONE empty, without text, and in the files that have to be empty.
Example:
from inventory file [login to view URL], in the excel file 1929 must have it inside:
where is written "XXX" the value must be “1929"
where is written "ZZZ" the value must be "MODA VOGUE Illustration - Fashion Cool Week"
where is written "YYY" the value must be "1054"
where is written "QQQ-QQQ" the value must be "1001-2000"
where is written “DESCRIZIONE” the value must be "Il termine moda … …" WARNING IN SOME FILE THAT VALUE WILL BE EMPTY, refer to the inventory file [login to view URL]
where is written “KKK” the value must be "1054"
Files should always go back to the same excel version of the templates provided and without any changes to the file's content.
We have 14 days maximum to create files,
We have several type of this work. This is only the first one.
In attachment a screenshot of Inventory 1001_2000.xlsx
Project ID: #15125454
About the project
50 freelancers are bidding on average $111 for this job
Hi, I can create more or less 1100 excel files using the supplied TEMPLATE files. Please share the excel file to check more deeply and understand the work process. Thanks
Hi, I can code a set of VBA macros to generate these files. The process will be more clear if you send the sample files. I can finish the task in 2 days. Also I m looking for a long term cooperation with you. Thanks
Hello Sir, we have 8 member team and we can start work right now just give us one chance we will do our best,awaiting ur answer.
Dear sir, Greeting, Old account has been closed new account start work. I've extensive experience doing the work very fast and accurate.I'll do the work absolutely perfect.
Dear i will complete your project with 100% accuracy. I will do my best. Please award me this project. Thanks I have 3 years experience in this field. Sir do you want perfect work and in your budget? If yes please More
!!! Dear Honor !!! We Can Help You Make That Happen !!! Let's discuss............. Choose wisely!! Cheers :)
In order to make your project a success, you need someone who has ample knowledge and a keen eye for detail, both of which I have. I read and understood your requirements but would like to create one excel file as samp More
I have gone through the project details, and understand what you are trying to achieve. We have completed a number of similar projects to yours. And we are experienced critical data research. ## A little about us ## More
Dear Next Employer I'm ready to show you samples of similar projects I've completed. Thanks' You can chat with me and let's get started
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I will automate all these process which you described in your project description. I have experience of creating Exce More
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
Hi, I have read Your project and think you will be happy after completing this project with me. Lets chat and talk more. Thanks
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start