Front page with the live date and following fields where a user can input and submit data
for both ATM 1 and ATM2 (can we split them out please and have 2 different sets of identical questions and have the info being submitted and saved in different sheets
Start of day cash balance: [enter amount]
Button which allows the user to submit the balance. This balance is then stored on another sheet which has the date in one column and the amount in another.
Withdrawals: [enter amount]
Deposits: [enter amount]
Cash in G4S [enter amount]
Cash out G4S [enter amount]
End of day cash amount [Reconciles? Y/N- formula to check whether the closing amount = start of day - withdrawals +deposits + cash in - cash out.
Flag if there is any difference
26 freelanceria on tarjonnut keskimäärin $123 tähän työhön
Excel VBA expert with more than 300+ reviews ok freelancer. I can implement it in 2 days. please assign me the project so that I can start with the implementation.
Hi, I have over 10 years of working experience as Excel VBA developer. Please share your file with me to review and we can discuss more in chat. I am available right away to work. Thanks
Hi, I am well versed with VBA and can help to create the reconciliation sheet in Excel. It would help to discuss further on this. Looking forward to your response. Thanks