Excel Project with Visual Basics
Budget: £20 – £250 GBP
Excel Project with Visual Basics
to use Visual Basics or a Macro to organise and export Remittance spreadsheet into a clients register excel document:
1. Sort Remittance in alphabetical order, plus payments for each tenant should all correlate.
2. create a separate overpayment list from original remittance list.
3. Take 6% of all figures
4. Then input it into Weekly Register.
5.Then identify who got paid.
I have uploaded a document with all the properties that should be in order in the excel document and attached an example invoice.
to use Visual Basics or a Macro to organise and export Remittance spreadsheet into a clients register excel document:
1. Sort Remittance in alphabetical order, plus payments for each tenant should all correlate.
2. create a separate overpayment list from original remittance list.
3. Take 6% of all figures
4. Then input it into Weekly Register.
5.Then identify who got paid.
I have uploaded a document with all the properties that should be in order in the excel document and attached an example invoice.