Personally, I'd try to keep all the data on one worksheet. And then just filter
or sort that sheet.
But maybe you could add another column with a formula like:
=text(a2,"mmmm")
(to get the month name)
And use one of these techniques:
Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm
Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html
Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb
Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb
brumanchu wrote:
Hello,
I have a workbook set up with a data entry sheet "Hours", and then twelve
worksheets named for each month of the year.
When the data is entered, it starts with the date (ex. 10/14/08) then there
are a couple of rows of data with the entry. Is it possible to set up a
macro that will evaluate the date from the input sheet "Hours" and then copy
that data to the sheet with the corresponding date (ex. October)?
Thanks for the help,
Bruce
--
Dave Peterson