Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook with about 25 worksheets (one for every employee) all with
the same information. I have a macro that I can run which takes all the sheets and creates a 'Master' sheet (merging all information) whenever I want to run it. What I would LIKE to do is create this master sheet based on a date range. For example, Column A is 'Date Assigned'. I would like to be able to create a master based on only the month of January, February, etc... Is this possible within the Macro or some other way? Also, could this be automated somehow every month (not THAT important)? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link Data from Multiple Worksheets | Excel Worksheet Functions | |||
extract data from multiple worksheets | Excel Worksheet Functions | |||
same data multiple worksheets | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |