I have a column in sheet1 with 3 names (Phil =I2, Jessie=I3 and Joseph=I4), each name has a spend amount associated for a given month(let's say July), because I already set a macro which looks that info for me and sends the results to cells(J2, J3, J4) in sheet1. Now what I'm trying to do is send that info to another sheet2, where I have columns for each month. Is there any way I can look for a specific cell with the month I need and paste under it? I would like to imput the variable and the macro would hv to send it to the typed month.
I come up with this:
Sheets("plan1").Select
Range("j2:j4").Copy
Sheets("Sheet1").Select
Range("N2").End(xlToLeft).Offset(0, 1).PasteSpecial