Add macros/vba/formulas to spreadsheet and tweak the design.

The document should be fully automated and all formatting and logic in place. The only thing I want to do is type the transactions and for the rest to be done itself. I have made a list of requirements. Please submit a proposal and I will send you the files if I think you are suitable for the job. A few people have tried this and they have all failed which is why I am resubmitting the job again. The level of knowledge required on Excel is high. If you have high level in VBA, macros, design and formulas, please submit a proposal. If the first one is successful then I will have others for you to do. 1. Random number generated at the top of the page and on the side of the page. This should be randomly generated when I choose it to be. Not randomly generated everytime I open the file. Numbers will follow a certain pattern. 2. Balances on both Excel tabs to be automatically shown depending on certain logic. The balance is only shown on the last transaction on that day. 3. Colours should alternative automatically between white and blue for each transaction. 4. Black lines should be shown around each transaction, these should be added automatically. Transactions can be different length and size. 5. Icons should be inserted automatically next to the transactions based on what I type. For example typing “Card Payment” will automatically insert the card icon. Typing “Direct Debit” will automatically insert the direct debit icon. 6. The list of icons shown in the middle of the page above the transactions should change depending on what icons are used in the statement. For example if the statement only has Card Payments, then this is the only icon that should be shown in the list. 7. Something on the date column to inform me when I type a date which is on a weekend. Dates on weekends are not allowed on statements. It should flag or highlight so that I can change it to another date 8. Add barcode and QR code. I will randomly generate these and send the images 9. Some design tweaks will be needed so that the design matches the original near to 100% 10. Icons should be copied over from the original documents which I will send. Icons need to be high quality. 11. Should be completed in Excel 2013 or Excel 2016. 12. Daily updates required as there will be a lot of different drafts.