ryancgarrett
Board Regular
- Joined
- Jun 18, 2011
- Messages
- 122
I am trying (unsuccessfully) to write some code to do the following. I have a sheet called "Journal" where all transactions are recorded. It looks like this:
I have a button on a form titled "Post Transactions" and when that is clicked two things need to happen. The first, I need something that will go down and find the next transaction that has not been posted (indicated by the word "Posted" in column D) and the word posted should be placed in column D. I can't figure out how to scroll to the last instance of posted because of the blanks in between, but I am positive there is a way to do it.
Secondly, the amount of the transaction needs to be taken from the debit or credit column, and placed on the next line of the accounts worksheet. So in my screenshot shown on the last unposted transaction, $400 should be placed in the debit column of the "Purchases" sheet, as shown below.
I don't even know where to start on this, any help would be greatly appreciated!
I have a button on a form titled "Post Transactions" and when that is clicked two things need to happen. The first, I need something that will go down and find the next transaction that has not been posted (indicated by the word "Posted" in column D) and the word posted should be placed in column D. I can't figure out how to scroll to the last instance of posted because of the blanks in between, but I am positive there is a way to do it.
Secondly, the amount of the transaction needs to be taken from the debit or credit column, and placed on the next line of the accounts worksheet. So in my screenshot shown on the last unposted transaction, $400 should be placed in the debit column of the "Purchases" sheet, as shown below.
I don't even know where to start on this, any help would be greatly appreciated!
