В роботі

Excel Files

I have a dataset with 220 folders, each containing one spreadsheet.

Each spreadsheet has a different name--they are named after television shows. Every spreadsheet has the same format. Here's what needs to be done.

First create a new spreadsheet named "RelatedFiles." The first column (Column A) should be named "Title" and the second column (Column "B") should be named "Words." The information in the first column is the file name of the spreadsheet in a folder, e.g. "AgentX." Information contained in the second column is taken from the column named "Concept" in that spreadsheet.

This process needs to be repeated for all 220 spreadsheets so that in the end, I have one spreadsheet containing all of the "Concept" information (in the second column) along with the file name in the first column.

Attached you will find four of the 220 spreadsheets as examples, along with a fifth spreadsheet that shows what the "RelatedFiles" spreadsheet should look like for information contained in these four files.

When I have chosen a freelancer for this project, then I will send the entire set of 220 spreadsheets.

Finally, I know very well that this is an easy task. Therefore, I expect that almost anyone here can do it. That means that price and speed of completion of this task are important considerations in choosing the freelancer.

Навички: Обробка даних, Excel

Показати більше: excel macro import project files, parsing excel file vb6 project, excel data entry project, excel customer satisfaction project survey, converting excel visual basic project, excel database codes project, import excel columns microsoft project, excel engineering design project management, combine files exe project, excel macro protect project, free excel template building project budget, embed flv files flash project, code compare excel files aspnet, excel inventory count project plan, create excel files mysql, code compare excel files find similar items, excel give thanks project, lock excel files, access read excel files, code compare excel files, locking excel files, j2ee reading excel files, fetch data excel files, combining excel files, combine excel files

Про роботодавця:
( 41 відгуки(-ів) ) Pittsburgh, Sweden

ID проекту: #15563817

Доручено:

MimiFL

Creating a VBA code (macro) that will loop through all folders in a single top level folder and processing files inside each folder. There will be only one file in every folder. From that file values from column Conce Більше

$20 USD за 0 дні(-в)
(308 відгуків(-и))
6.5

60 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $25

mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can help you with excel files kindly PM me. Relevant Skills and Experience Data Processing, Exc Більше

$30 USD за 1 день
(217 відгуків(-и))
7.3
hdlong66

Hello, I will do "RelatedFiles" with 2 columns "Tile" and "Words" from provided 220 spreadsheets. I am ready to start. Best regards, Hoang Relevant Skills and Experience I've done 6 similar projects in the past - to m Більше

$30 USD за 1 день
(107 відгуків(-и))
6.7
TonmoyRoy111

Dear Client This is pretty straightforward work. It can be done using vba macro. I can do this task accurately within the specified time. Kindly contact me for further details. Roy

$30 USD за 1 день
(216 відгуків(-и))
6.2
BithiXpert

Hello Dear, I am an expert in Data Entry, Data Processing, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will pr Більше

$30 USD за 1 день
(171 відгуків(-и))
6.3
gangabass

I can provide you RelatedFiles Excel file + you'll get simple Windows program that will allow you to select source folder and after you click Start button it will generate output spreadsheet for you. Relevant Skills a Більше

$35 USD за 0 дні(-в)
(117 відгуків(-и))
5.9
qhairil

So, basically we should enter data for 2 column on relatedfiles.xlsx. Column a with each file name and column b with data from column concept of each excel file. Will complete it in less than 1 day. Relevant Skills Більше

$25 USD за 1 день
(34 відгуків(-и))
5.7
$29 USD за 1 день
(47 відгуків(-и))
5.6
binaryromel

Hi there, I'm excel expert and understand your project. I can do this. I'm ready to start immediately. Thanks, Mohiuddin.

$15 USD за 1 день
(92 відгуків(-и))
6.0
nagybatonyi

My approach offers a macro with the usual Open file dialog to identify the current input and output files and and other controls if necessary. Relevant Skills and Experience I have a university degree in economics and Більше

$20 USD за 0 дні(-в)
(62 відгуків(-и))
5.7
osmemon

I ll complete this work in 30 Minutes. I ve 7 years of experience in excel and VBA. see my profile for client reviews. Relevant Skills and Experience Excel VBA Proposed Milestones $30 USD - only Looking for your res Більше

$30 USD за 1 день
(28 відгуків(-и))
5.4
nashid1234

Dear please check my all profile reviews..i can do this for you easily...you can trust me and my professionalism..hope you may now reply me..thanks in advanced... Relevant Skills and Experience Excel Proposed Milesto Більше

$20 USD за 1 день
(61 відгуків(-и))
5.0
Exactwork1

Hi Sir, I am able to create one spreadsheet with all these 220 spreadsheet specify data which you instruct in your description with proper fields and accuracy Relevant Skills and Experience Sir, I Also have Great Expe Більше

$30 USD за 1 день
(38 відгуків(-и))
4.8
prabakarm23

I have worked on similar projects before, If awarded i can make it with 100% accuracy and Satisfaction Relevant Skills and Experience I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creati Більше

$30 USD за 1 день
(46 відгуків(-и))
4.5
$10 USD за 1 день
(16 відгуків(-и))
4.4
SmartestLancer

Hello sir, Thankful to you for your job post. I have just carefully read your job post. The instruction of adding all folders and spreadsheets details into one spreadsheet is crystal clear. Relevant Skills and Experie Більше

$25 USD за 1 день
(13 відгуків(-и))
3.9
mhfsha

I just check the description would be a pleasure to assist you on your project. looking forward to discuss in the chat.

$10 USD за 1 день
(14 відгуків(-и))
3.6
mehulvariya7

"===============Too Easy For Me=============== Excel, Research, Data Entry I have a more then 3 years of experience in excel, Research and data-entry." Relevant Skills and Experience "Excel, Data entry, Research I kno Більше

$20 USD за 1 день
(13 відгуків(-и))
3.4
javidj18

I have gone through the document. I can complete it within next 3 hours. Relevant Skills and Experience Excel - 4 years Proposed Milestones $10 USD - Data Entry

$10 USD за 1 день
(15 відгуків(-и))
3.8
ttthivi

Hello, I read your requirements and understood very-well and ready to start work from now. I assure that I will work with honesty if you give me the chance. I can finish this work within a day. Relevant Skills and E Більше

$10 USD за 1 день
(8 відгуків(-и))
2.9
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Media Market Більше

$25 USD за 1 день
(6 відгуків(-и))
2.6