Hi pilotdata!
The easiest solution is that to create entries in single sheet. If you can
email me the structure of the data that you use and the variables, I can even
help you create a sheet myself. The reporting requirements can be easily met
by the Pivot table. Additionally when you want a different sheet for each of
the pilots, you can have two options:
1. individual sheets linked to the base sheet (in which you enter data).
(the file size will be bigger)
2. single sheet with a drop down list of all the pilots, it will give you
the data based on the selection. (the file size will be smaller)
--
Trinetra
The Good One
"pilotdata" wrote:
Hello All:
I've already found a great deal of help reading the archives, but I'm
now stuck with a structural issue. I am building a spreadsheet to
track recurring training requirements for each of the pilots in my
corporate flight operation. This is my first attempt at vba and Im
stuck in a few spots. I have one sheet for each pilot with a list of
training requirements on each. The last training date is entered for
each requirement and the sheet calculates the next due date for each of
15 training requirements based on different variables.
My largest problem is creating a report sheet that aggregates all of
the data, with all of the pilots, training requirements, and due dates
grouped by month and sorted by due date. Should I be feeding all of
the data into one sheet & then using a pivot table? If so, how do I
get the data all together when I don't know before hand how many sheets
I'll have? Should I be using filters, a macro, or a pivot table to do
what I want? Should I be structuring the entire project differently?
Currently, there are 8 pilots but the solution needs to be flexible
enough to accommodate additional pilots (hence additional sheets)and
additional training requirements. Any help is greatly appreciated &
I'll be happy to email my latest file for review (it doesnt look like i
can attach it to this post).
Thanks!
Chris
--
pilotdata
------------------------------------------------------------------------
pilotdata's Profile: http://www.excelforum.com/member.php...o&userid=28664
View this thread: http://www.excelforum.com/showthread...hreadid=483371