Hi All,
New to the forum
!
Thank you in advanced for your help.
I am doing my personal finance in a work book and am looking to minimize input time.
Each week I download my bank role and have it on a spread sheet. I go through and manually input the value to the cell associated with to the relevant cost center. This is where I would like to minimize input time and I believe something as follows might do it.
I'd like to be able to place an acyromn for the account name of the expenditure or income. For example, I put E.O next to a value for E(lectronics).O(ther) (Electronics being the primary and Other being a secondary category underneath;
Variable Expenditure
Once I've selected the relevant acronym, or it dosent even have to be an acronym it could be the full name, a piece of code takes then executes and copies the value from the relevant cell and allots it in the correct cell by date in a seperate spreadsheet (same work book).
This is the form on my bank role;
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
To me, this sounds like VBA & SQL but I new to all this and could do with some advice / pointing in the right direction!
Thanks
New to the forum
!Thank you in advanced for your help.
I am doing my personal finance in a work book and am looking to minimize input time.
Each week I download my bank role and have it on a spread sheet. I go through and manually input the value to the cell associated with to the relevant cost center. This is where I would like to minimize input time and I believe something as follows might do it.
I'd like to be able to place an acyromn for the account name of the expenditure or income. For example, I put E.O next to a value for E(lectronics).O(ther) (Electronics being the primary and Other being a secondary category underneath;
Variable Expenditure
Electronics
Computer
Other
Theses categories are in the first cell of my P&L sheet in Row A.
Once I've selected the relevant acronym, or it dosent even have to be an acronym it could be the full name, a piece of code takes then executes and copies the value from the relevant cell and allots it in the correct cell by date in a seperate spreadsheet (same work book).
This is the form on my bank role;
| 29-Jul-13 | ATM | BARCLAYS BNK 28JUL | - | 40 | -£98.93 |
| 29-Jul-13 | ATM | NOTEMACHINE 26JUL | - | 20 | -£118.93 |
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
To me, this sounds like VBA & SQL but I new to all this and could do with some advice / pointing in the right direction!
Thanks
