Writing Excel macros
Employer
[no-member:pro]Vladimir[/no-member:pro]Vladimir
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsBank transfer, Electronic money
Acceptance of requestsclosed
Project description
You need to write a macro for Excel to form the act of work performed.
Data is taken from the “work” sheet of the same file. The form of the act on the sheet "AKT" The necessary lines are marked in column M by affixing the number of the generated act (in the attached file "12"), plus filtered by column F. The act is written into the same file with a new sheet (in this case, a sheet with the name “AKT ZRI 12” must be formed and stored).
Data is taken from the “work” sheet of the same file. The form of the act on the sheet "AKT" The necessary lines are marked in column M by affixing the number of the generated act (in the attached file "12"), plus filtered by column F. The act is written into the same file with a new sheet (in this case, a sheet with the name “AKT ZRI 12” must be formed and stored).
