Hi, I am trying to create a spreadsheet to track expenses for a club that I belong to. The front sheet is the "master" sheet where all expense transactions would be entered by date, one for each row, the number of rows growing as the year progresses, and each row has a drop down box for the category of expense, eg subs, admin, insurance, speaker fees etc (about 10 categories). I would then like to copy the data from each row to another sheet, like a sheet for subs, another for admin etc, placing the data in the next available row, so the sheet for each category will grow with time and I can add formulae to track the totals etc.
I was thinking that I could use the "worksheet change event" to trigger the copy but have got into a big mess. Any ideas please?