File Value to Cell based on Date and Catergory Selected

[WillJ]

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

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;

[TABLE="width: 1029"]
<colgroup><col><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD="align: right"]29-Jul-13[/TD]
[TD]ATM[/TD]
[TD]BARCLAYS BNK 28JUL[/TD]
[TD]- [/TD]
[TD]40[/TD]
[TD]-£98.93[/TD]
[/TR]
[TR]
[TD="align: right"]29-Jul-13[/TD]
[TD]ATM[/TD]
[TD]NOTEMACHINE 26JUL
[/TD]
[TD]- [/TD]
[TD]20[/TD]
[TD]-£118.93[/TD]
[/TR]
</tbody>[/TABLE]


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