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.