Hi all, basically here is what I do manually
When I download my bank statement recurring (Direct Debits) entries come up like these two below -
07/05/2014 NSPCC (8.00)
01/05/2014 TV LICENCE MBP (12.12)
I download this onto a file called "July 2014 data" to a tab called "[Month]", i.e. whatever the month is.
I then type in these values in my cash flow (another file called "Cash Flow 2014 July - June 2015", on tab "Cash Flow") - so in cell B13 I have 'TV Licence' and then I look for the month in the columns and type in £12.12. Obviously if there is alot of Direct Debits this is time consuming.
Could a macro look at a list of data (list of Direct Debits), and search for these in a list of bank transactions (always will be 1st to 31st of a month), and then when it finds the transaction (i.e. it finds NSPCC) it matches the amount to the amount on the list, and if its in this case £8 it displays this on my cash flow on a certain row, and column (the row will always be same but the column will change depending on the month - could the macro request this at the start from the user? ). If the amount doesnt match then I would still like the value displayed in the cash flow but highlighted (cell fill colour) red.
Also - there is an extension to this which I thought I would divulge later - step by step. Basically searching through the transactions for a type of expenditure and placing the total value to a list of types of expenditure on another tab (columns = type of expenditure), but also placing according to the week which the date of the transactions falls in (row).
If you want to explain further I can.
By the way if this is asking alot please let me know.
Kind Regards
Amish
When I download my bank statement recurring (Direct Debits) entries come up like these two below -
07/05/2014 NSPCC (8.00)
01/05/2014 TV LICENCE MBP (12.12)
I download this onto a file called "July 2014 data" to a tab called "[Month]", i.e. whatever the month is.
I then type in these values in my cash flow (another file called "Cash Flow 2014 July - June 2015", on tab "Cash Flow") - so in cell B13 I have 'TV Licence' and then I look for the month in the columns and type in £12.12. Obviously if there is alot of Direct Debits this is time consuming.
Could a macro look at a list of data (list of Direct Debits), and search for these in a list of bank transactions (always will be 1st to 31st of a month), and then when it finds the transaction (i.e. it finds NSPCC) it matches the amount to the amount on the list, and if its in this case £8 it displays this on my cash flow on a certain row, and column (the row will always be same but the column will change depending on the month - could the macro request this at the start from the user? ). If the amount doesnt match then I would still like the value displayed in the cash flow but highlighted (cell fill colour) red.
Also - there is an extension to this which I thought I would divulge later - step by step. Basically searching through the transactions for a type of expenditure and placing the total value to a list of types of expenditure on another tab (columns = type of expenditure), but also placing according to the week which the date of the transactions falls in (row).
If you want to explain further I can.
By the way if this is asking alot please let me know.
Kind Regards
Amish
