Excel Data Entry - Find & Replace - Create Files

Cancelled Posted 6 years ago Paid on delivery
Cancelled 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

Data Extraction Excel Scripting

Project ID: #15125454

About the project

50 proposals Remote project Active 6 years ago

50 freelancers are bidding on average $111 for this job

Ibrahim185

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

$50 USD in 3 days
(710 Reviews)
8.3
motiur03

Dear Hiring Manager, You may see my profile here: https://www.freelancer.com/u/motiur03.html I am writing to apply for the position of Virtual Assistant. I possess seven years of experience as a virtual assistant More

$30 USD in 2 days
(271 Reviews)
7.9
Khurramz

Hi I couldn't see any attachment. Could you please send me the files via chat? .

$49 USD in 3 days
(404 Reviews)
7.9
bouslimi1979

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

$222 USD in 3 days
(322 Reviews)
7.8
TonmoyRoy111

A proposal has not yet been provided

$200 USD in 3 days
(498 Reviews)
7.8
pandey2008

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.

$71 USD in 1 day
(417 Reviews)
7.5
sujonmax2

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.

$155 USD in 3 days
(169 Reviews)
7.0
ESOLUTIONSSS

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

$30 USD in 10 days
(192 Reviews)
6.9
oadsmedia

!!! Dear Honor !!! We Can Help You Make That Happen !!!  Let's discuss.............  Choose  wisely!! Cheers :)

$50 USD in 1 day
(84 Reviews)
6.8
ponnarasiBabu

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

$150 USD in 14 days
(125 Reviews)
6.7
devi222

Hi sir, I am expert in excel Handling, i can create macro to sort out/remove any unwanted data(even from urls or from any where in the sheet). I have done 300+ excel tasks like matching the results, comparing using More

$55 USD in 0 days
(161 Reviews)
7.0
diamond247

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

$150 USD in 3 days
(154 Reviews)
6.7
Dataworker44

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

$111 USD in 3 days
(161 Reviews)
5.8
vsprybhanu

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

$250 USD in 3 days
(111 Reviews)
5.9
renesontiongson

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.

$80 USD in 1 day
(73 Reviews)
5.7
AkilaArun

Hi, I am interested in working on this task. I saw the Sample picture and read through the requirements. The requirement is clear. I can start off with a quick chat where I can explain my understanding about the tas More

$40 USD in 1 day
(52 Reviews)
5.7
sajibdigital

Hi, I have read Your project and think you will be happy after completing this project with me. Lets chat and talk more. Thanks

$100 USD in 3 days
(83 Reviews)
5.8
mhfsha

I can do this project perfectly if you need a perfect project please contact me

$30 USD in 1 day
(138 Reviews)
5.6
tasleem83

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

$250 USD in 3 days
(88 Reviews)
5.3
sonarkaushik

I can do this excel work

$99 USD in 2 days
(43 Reviews)
5.6