Write a VB script in xls for copying some lines of data depending on its content to other sheets
Budget: $30 – $250 USD
I have an complete list of company procedures listed in an excel file on the first sheet. When we have new people join the company, they need to only read those procedures that relates to their department, so we have vertical columns by departments, for example ME, EE, Accounting, and so on.
In those columns, we highlight the importance/urgency of reading from 1 to 3, or NA if it does not related to their departement. For example, an electrical engineer (EE) does not need to read accounting procedures. Then an NA will be listed.
Now I would need a VB script that scan this entire first sheet, scan the headers, and create a new sheet for every related department listed in the header till a black cell is found (to start with ME, EE, and so on). Then it should scan for example the ME column, if it is 1, 2 or 3, it should copy that line to the ME sheet, if NA or anything else, it just ignores this line.
So this way we can keep update, add or remove procedures on the first sheet only, and it will automatically update all ME, EE, .. sheets automatically. Those ME, EE, .. sheets will then be provided to the new employees.
Note also that you will need to work on the formatting, so it prints out nicely on one (or multiple) A4 sheets.
If you bid on this project, please include an xls file with previous work, so I can review your coding style.
See the provided xls file, in the first sheet, the expected result following the VB script run, is shown in the 2nd sheet.
In those columns, we highlight the importance/urgency of reading from 1 to 3, or NA if it does not related to their departement. For example, an electrical engineer (EE) does not need to read accounting procedures. Then an NA will be listed.
Now I would need a VB script that scan this entire first sheet, scan the headers, and create a new sheet for every related department listed in the header till a black cell is found (to start with ME, EE, and so on). Then it should scan for example the ME column, if it is 1, 2 or 3, it should copy that line to the ME sheet, if NA or anything else, it just ignores this line.
So this way we can keep update, add or remove procedures on the first sheet only, and it will automatically update all ME, EE, .. sheets automatically. Those ME, EE, .. sheets will then be provided to the new employees.
Note also that you will need to work on the formatting, so it prints out nicely on one (or multiple) A4 sheets.
If you bid on this project, please include an xls file with previous work, so I can review your coding style.
See the provided xls file, in the first sheet, the expected result following the VB script run, is shown in the 2nd sheet.