Making a new list (stacking?)

[mailrail]

I really didn't know how to search for what I need so I'll try and describe
this in a way that someone will hopefully understand...

On a separate worksheet, I need to create a new list from certain criteria
from another sheet. For instance, if Run #1 is a regular workday for a
driver, which would be listed as "W" on the schedule sheet, I need to be able
to add his run number to a list on another sheet (hopefully in numerical
sequence) so that when the list is populated, I'll have a tracking sheet (on
the other sheet) to be able to make notes, etc., about the regular driver's
performance. My "blank" sheet has a constant 25 rows and the number of
regular drivers in a day would populate (in order, hopefully) down the list
starting at row one. Is this possible?

 

[Joel]

You need to write a VBA macro. there are two different types that could work

1) Worksheet_change: when ever a range of cells get changes will activate
the macro. this macro can add information to a second worksheet.

2) Manually activated macro: You can run a macro once a day that take
certain f\data from one worksheet and add it to another worksheet.