Hi everyone.
I've been given some VBA to perform a transfer of money onto different balance sheets in 1 workbook.
The problem I have is two-fold. Please see that attached workbook.
Within each sheet I have added a simple transfer table in the top right hand area. This allows a user to transfer funds from an opening balance on one sheet and add it to another. There are 3 years to be shown so I thought of adding 3 transfer buttons 1 for each year.
Everything works except for the 2 problems.
1. If you don't add a figure in the first row then it won't take away any figures entered below it.
2. Also it takes away 6 instead of 1 if entered. Please help!!! The code is as follows
THANKS!!!!
[code]
Bookmarks