Create multiply Excel files (or one Excel with multiply worksheets, from MasterExcel.
- or -
Post a project like this2236
$$
- Posted:
- Proposals: 10
- Remote
- #1906848
- Awarded
Excel and VBA expert. Professional OCR. PDF to Excel Conversion. Data management, Translations English Russian
Hua Hin
1104630208270768831854683101762913168011783582208746020915222099818
Description
Experience Level: Intermediate
Our system generates one master Excel (longlist), which needs to be "broken" into separate files or one Excel files.
1. The first 4 lines in the master Excel will be copied to all separate files; this is the time stamp information.
2. The next 5 lines (header); When column A (Level) is equal to "0", a new separate list is generated with a header that includes Five lines above the "0" line (begin with line "Item Number:".
3. Each separate file includes format with colored header-line, pre-define column wide & visible borders (from A-H columns, till the end of list).
4. I included a sample of master list (contains 6 shortlists) & sample of the required generated format of a separate list/excel.
5. The script will be able to generate from the "master" Excel at least 500 separate Excel files.
6. The filenames/worksheets names will include the "Item Number:" field value + Item Revision
(for sample: “PRDr11Q5750z-02 11 C18-0312 BOM_Explosion_Report.xlsx” (Multiply spaces will convert to one space).
7. The outcome should be in separate workbooks files, using VBA Excel macro, inside of which you click a button, labeled "Open BOM" to open the Master Excel File. Then click on a button labeled "Split BOM" and it would break the list into separate Excel files.
8. The documented source code will be provided as part of Job.
1. The first 4 lines in the master Excel will be copied to all separate files; this is the time stamp information.
2. The next 5 lines (header); When column A (Level) is equal to "0", a new separate list is generated with a header that includes Five lines above the "0" line (begin with line "Item Number:".
3. Each separate file includes format with colored header-line, pre-define column wide & visible borders (from A-H columns, till the end of list).
4. I included a sample of master list (contains 6 shortlists) & sample of the required generated format of a separate list/excel.
5. The script will be able to generate from the "master" Excel at least 500 separate Excel files.
6. The filenames/worksheets names will include the "Item Number:" field value + Item Revision
(for sample: “PRDr11Q5750z-02 11 C18-0312 BOM_Explosion_Report.xlsx” (Multiply spaces will convert to one space).
7. The outcome should be in separate workbooks files, using VBA Excel macro, inside of which you click a button, labeled "Open BOM" to open the Master Excel File. Then click on a button labeled "Split BOM" and it would break the list into separate Excel files.
8. The documented source code will be provided as part of Job.
Zadok S.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
28 Feb 2018
Israel
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