VBA - run macro from condition

[panther]

Hello, I need help! I have a worksheet that I would like to transfer data from sheet to sheet. Need to know the best way to do this as the macro will be added onto later. Have mostly seen threads regarding making 31macros and using a selection box to pick the macro but would like something based on the 1-31 which is already on the spreadsheet and you only need to click the one macro run button.

The 1-31 is going to be yesterdays day number... ie 2 (novermber 2).

a1= 1-31. Example... a1=1, copy b1, paste c1
a1=2, copy b1, paste c2.

Looking for the best possible way to do something like this.
Thanks

[arlu1201]

Its not very clear on what you want. Why dont you attach a sample workbook so we can help you better and faster?