Excel automation expert
- or -
Post a project like this2884
$$
- Posted:
- Proposals: 7
- Remote
- #1161685
- Awarded
Description
Experience Level: Intermediate
Description of excel work: We need an expert in automating Excel. Our requirement is to use a spreadsheet to automate as follows;
- As per the attached “Filegen2.xlsx", in sheet “Filename”, we enter data we require to be used as the filenames.
Using the data in worksheet “Content” match any columns in sheet “filegen” and place data in any matching headings, in appropriate columns
- Once complete, be able to trigger a process that will create as many separate files as there are rows in “Filename” in a delimited CSV format, each file having the merged content name in “filegen”
- We need to use this spreadsheet for different “filegen” headers and data.
Extra notes:
- As per the attached “Filegen2.xlsx", in sheet “Filename”, we enter data we require to be used as the filenames.
Using the data in worksheet “Content” match any columns in sheet “filegen” and place data in any matching headings, in appropriate columns
- Once complete, be able to trigger a process that will create as many separate files as there are rows in “Filename” in a delimited CSV format, each file having the merged content name in “filegen”
- We need to use this spreadsheet for different “filegen” headers and data.
Extra notes:
Alan W.
100% (89)Projects Completed
93
Freelancers worked with
69
Projects awarded
52%
Last project
20 Sep 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies