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.
60 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $25
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
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