View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Husker87 Husker87 is offline
external usenet poster
 
Posts: 35
Default Can I copy data (Values) from one sheet to another with macro

Hello all,
Im trying to write a macro. I have 12 identical worksheets, one for each
month of the year. Each sheet has a drop down in cell B3 with the 12 months
in it which comes from another (13th) sheet. A lot of data gets entered into
each monthly sheet and is pretty much the same month to month. When filling
out a new month Id like the user to be able to select a different month with
the drop down on the current sheet they are working on and click a macro
button that would copy the values from that month to the current worksheet
they are working on. I cant seem to get the macro to recognize the value in
B3. Help.