Excel Data Entry - Find & Replace - Create Files

已取消 已发布的 6 年前 货到付款
已取消 货到付款

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

项目ID: #15125454

关于项目

50个方案 远程项目 活跃的6 年前

有50名威客正在参与此工作的竞标,均价$111/小时

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 在3天内
(710条评论)
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 更多

$30 USD 在2天内
(271条评论)
7.9
Khurramz

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

$49 USD 在3天内
(404条评论)
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 在3天内
(322条评论)
7.8
TonmoyRoy111

A proposal has not yet been provided

$200 USD 在3天内
(498条评论)
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.

$71USD 在1天里
(417条评论)
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 在3天内
(169条评论)
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 更多

$30 USD 在10天内
(192条评论)
6.9
oadsmedia

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

$50USD 在1天里
(84条评论)
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 更多

$150 USD 在14天内
(125条评论)
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 更多

$55 USD 在0天内
(161条评论)
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 ## 更多

$150 USD 在3天内
(154条评论)
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 在3天内
(161条评论)
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 更多

$250 USD 在3天内
(111条评论)
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.

$80USD 在1天里
(73条评论)
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 更多

$40USD 在1天里
(52条评论)
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 在3天内
(83条评论)
5.8
mhfsha

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

$30USD 在1天里
(138条评论)
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 在3天内
(88条评论)
5.3
sonarkaushik

I can do this excel work

$99 USD 在2天内
(43条评论)
5.6