Macros slicing the report into books
Employer
[no-member:pro]Sergey[/no-member:pro]Sergey
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsBank transfer
Acceptance of requestsclosed
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
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
