VBA copy and paste to a specific cells for a given month


This Content is from Stack Overflow. Question asked by felipemayer

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.

This Question and Answer are collected from stackoverflow and tested by JTuto community, is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?