Help with macro to copy data to a designated worksheet

[brumanchu]

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]

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