blackie42
04-25-2008, 04:41 AM
Hi,
Have a process where I have to transfer individual items from a bulk number (held in one cell) to other bulk number(s) (held in different cells). At the moment I'm doing it by Cell A1: = 10,000.00-23.56-44.45 (total displayed is then 9931.99 - Cell A12: = 5000.00+23.56+44.45 (total displayed is 5068.01).
So basically transferring cash amounts between cells by use of +/-.
I was thinking I could maybe create a userform to automatically update both cells by just entering the number - but my question is how do I keep the record of what I moved in the cells - I suspect doing this will just update the total - but I need to keep an audit of what was moved i.e. in the same cell format as doing it the long way +23.56 on one side -23.56 on the other.
Any ideas please
thanks
Jon
Have a process where I have to transfer individual items from a bulk number (held in one cell) to other bulk number(s) (held in different cells). At the moment I'm doing it by Cell A1: = 10,000.00-23.56-44.45 (total displayed is then 9931.99 - Cell A12: = 5000.00+23.56+44.45 (total displayed is 5068.01).
So basically transferring cash amounts between cells by use of +/-.
I was thinking I could maybe create a userform to automatically update both cells by just entering the number - but my question is how do I keep the record of what I moved in the cells - I suspect doing this will just update the total - but I need to keep an audit of what was moved i.e. in the same cell format as doing it the long way +23.56 on one side -23.56 on the other.
Any ideas please
thanks
Jon