Automation of a spreadsheet

Hi

I've attached a sample sheet, of my data input - this is then analysed using pivot tables.

There are a few automation processes that I would like to happen in the sheet - basically I want to input the least amount of information and allow excel to do the rest.

Although the sample sheet doesn't show it I've already got Col A (QTR), Col C (DAY), Col D (MONTH), Col E (WK No) automated on input of date in Col B - thanks to daddylonglegs and vba Noob.

For the rest I need help, so here goes:

1. Col F (INC/EXP) - this will be manually input.
2. Col G (Dept) - manually input
3. Col H (Amt) - manually input
4. Col I (category) - enter manually
5. Col J (Type) - automatic by excel based on entry in Col I
6. Col K (vat) - automatic by excel based on entry in Col J
7. Col L (ref) - automatic by excel as the next sequential number (once the data in autofiltered by ascending date) i.e. PCV273 will be inputted manually first, then when the next cash exp in Col J appears (after the data is auto filtered by ascending date - Col B - excel will place PCV274 in the corresponding cell. Same goes for Chq numbers.

So can someone have a look at this and see what they can come up with - I don't even know what functions to use!!

Any help will be much appreciated.

Regards

Tony