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.
Thank you for your help
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.