Probably VERY easy to create a database for you, Chris. I'm willing to take
a look at your Excel file. Also, I meant that you'd start with all your data
on one worksheet. Use Autofilter and subtotals features:
http://www.officearticles.com/excel/...soft_excel.htm
http://www.officearticles.com/excel/...soft_excel.htm
But when/if you want individual reports for each pilot, you save the file,
run a macro like the one I gave you, print the entire workbook, close the
file without saving so you don't have those extra worksheets anymore.
Make sense? Sure, there's lots of better ways...they're just not as cheap as
this one. :) I do VBA project mgmt for a living now...no longer a P3
mechanic. LOL
************
Anne Troy
www.OfficeArticles.com

"pilotdata" wrote
in message ...

Hi Anne:

Thanks for the fast reply and for the ideas. The example that you
supplied seems to go the other way, that is, to take data from one
sheet and distribute it to others. I'm not sure how I could modify the
code to do the opposite.

You're probably right about Access being the answer, but I've never
used it and wouldn't even know where to begin. Perhaps its time for me
to take an Access basics class so that I have some new tools to use :)


Thanks Again,
Chris


--
pilotdata
------------------------------------------------------------------------
pilotdata's Profile:
http://www.excelforum.com/member.php...o&userid=28664
View this thread: http://www.excelforum.com/showthread...hreadid=483371