Hullo!

I hope someone can help me out here, my mind has gone completely blank on how to do this, although i'm sure it can be done quite easily.

Right. Over the weekend, my fiancee's dad came over and help set up a budget sheet on excel. It works out all the spending and keeps a track of everything nicely.

Now, as an addition to this, i want to add a another sheet to the workbook detailing my fuel costs.

On the main budget sheet, it details every penny going in and out and will help us forecast future costs, and help us save money as we've got a wedding to pay for!!

Anywho, through the main budget transactions, fuel gets added to it as an expense. It also shows the date i purchased it and the amount i paid.

I'd like my fuel cost sheet to automatically pull all the data from the main transaction sheet (sheet 1) which are detailed as Diesel and duplicate it on the fuel costs sheet (sheet 2). Then i can go and do lots of sums on my petrol usage lol... but to start with, i need the data.

Is there a way you can lookup all the cells which contain the word 'diesel', and then copy several cells that correspond to that row and place it on sheet 2?

Any help would be great :D