Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. "mailrail" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stacking data without stacking everything | Charts and Charting in Excel | |||
making a list | Excel Discussion (Misc queries) | |||
making a list ?¿ | Excel Worksheet Functions | |||
Making a list | Setting up and Configuration of Excel | |||
Making a new list | Excel Discussion (Misc queries) |