Klartigue
10-19-2011, 08:58 AM
I have a spreadsheet that tracks trades that contain settlement dates located in column E. If the settlement day is anything from today and on, that means the account still has a pending transaction. I would like to write a macro that tracks all the accounts with pending transactions. I will manually put the transactions in each day, but i want the macro to update everyday so i only have a list of pending transactions. Therefore, after the settlement date has passed, i would like that transaction (or row) to be taken off the sheet and deleted.
Any ideas?
Thanks!
Any ideas?
Thanks!