View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brumanchu brumanchu is offline
external usenet poster
 
Posts: 18
Default 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