Master Sheet and Subsets [Closed]

Report

JoHubb - May 10, 2015 at 03:42 PM

Hello,
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!

John
PS Running Excel Professional Plus 2010; W7x64.

Master Sheet and Subsets
Excel master sheet sub sheets - How-To - Excel
Master sheet meaning - Forum - Excel
Autopopulating multiple sheets from one main sheet ✓ - Forum - Excel
Excel - Copy data from a range of sheets to a master sheet - How-To - Excel
Auto populate rows from master sheet to other sheets Excel 2013 ✓ - Forum - Excel

Master Sheet and Subsets [Closed]

Your reply

Subscribe To Our Newsletter!