1
Сергей
no recommendations
no complaints
Closed
Project title: Macros slicing the report into books
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer
Acceptance of requests: closed
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Bank transfer
Acceptance of requests: closed
Project description:
The macro should:
1. Divide the book into several books
2. Divide the book into several books, according to tabs highlighted in orange
3. "filtering" - by columns, the distributor and the criterion (the criterion on the necessary sheets is highlighted in orange with an explanation of what is needed).
4. Remove columns not highlighted in purple.
5. The column highlighted in purple should be a cap (stand in line "A")
6. In divided files should not be formulas and summary tables
7. The sheets not marked in orange should be removed.
8. Formation of a name such as "distributor for which the report is cut" & "text.xlsx"
Preferably execution until 24.01.2017 17:00-17:30
The macro should:
1. Divide the book into several books
2. Divide the book into several books, according to tabs highlighted in orange
3. "filtering" - by columns, the distributor and the criterion (the criterion on the necessary sheets is highlighted in orange with an explanation of what is needed).
4. Remove columns not highlighted in purple.
5. The column highlighted in purple should be a cap (stand in line "A")
6. In divided files should not be formulas and summary tables
7. The sheets not marked in orange should be removed.
8. Formation of a name such as "distributor for which the report is cut" & "text.xlsx"
Preferably execution until 24.01.2017 17:00-17:30
