View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chersie Chersie is offline
external usenet poster
 
Posts: 10
Default dates linked to data

I have worksheet one set up as a form to gather information. I have twelve
consecutive worksheets for the months of the year.

I would like to link the data from sheet1 to the appropriate month the data
is for. I am not sure how to do this.

I want all input data from January 1st to January 31st from the form to go
to the worksheet January, February 1st to February 29th to go to worksheet
February, etc.

How can I do this?

Thanks in advance for your help!!!