Hi everyone!
I have 2 Worksheets in the same workbook. I'm trying to figure out how to find a value on the first sheet(Template) and value paste it into a specific cell on the second sheet(YTD) by looking up a row value and looking up a column value and using that to determine the cell to paste to. If possible I want to assign it to Command Button 1(Update) which already performs a HideRows Command.
So for the example below, when I click the Update button, I want the Macro to paste the values from Range J15:J21 into the table on the YTD tab based on the persons name and the Column reference Template!M2.
I don't even know where to begin on this, I've tried to find similar examples but haven't found anything I've been able to rework to fit my examples. Any guidance would be greatly appreciated!
This is currently the code attached to CommandButton1 that I would like to add on to, if possible.
Value Paste VBA Example.xlsm
Bookmarks