I am currently trying to create a macro that does the following. There are two sheets involved, lets call them A & B. I first would like B:N to be cleared on sheet B. On sheet A, the user pick one number from 1-12. This number of month they want copied from sheet A over to sheet B. For example, if they choose 11, they want February- Dec copied from sheet A to B. If they chose 6, they would want July to Dec copied from sheet A to B.
B:N, is essentially Jan-Dec on each sheet and they are identical.
Please let me know what you think. First time poster,