Master Sheet and Subsets

JoHubb - May 10, 2015 at 03:42 PM
I use Excel for keeping track of flights in a flight simulator. At the moment I have everything on a master sheet. There are 20 columns and 285 rows at the moment. Data are added by rows.

The data comprising the Master Sheet are in four subsets: Free Flights; Charters; BOAC; Argonaut.

I add data to the Mastersheet and the subsets are colour coded. I plan to continue entering new data this way. However, I would like the data in the subsets to be automatically copied to separate worksheets in the same workbook.

Three of the columns use simple arithmetic addition to keep running totals of hours flown, distance travelled, and fuel consumption.

I am an Excel user, and have very little understanding of formulae, or how Excel works. If you can give me some advice on how to proceed, I'd be grateful. If it is likely to be too complicated for a non-expert, please tell me and I will pay someone to do the work for me.

Thanks for your help!

PS Running Excel Professional Plus 2010; W7x64.