Help with macro to copy data to a designated worksheet
 

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

Help with macro to copy data to a designated worksheet
 

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