tjur
04-29-2019, 04:50 PM
Hi there - I'm brand-new to VBA (as in the last 3 days) and I've been asked to take values from a pivot table and paste the values into a column in another sheet if the column title on the other sheet matches the prior month from today's date. The intent is for someone to update the pivot table and 'lock' the values in another sheet with the click of a button.
In the example I've attached, the March data is currently populated with Vlookups from the pivot table. Can I use VBA to copy/paste just these cells based on matching the month, or is there a better way to move the pivot table values to the new spreadsheet without Vlookups? So far, all of the code examples I've found online have all been about searching through rows to find matches and then copying the entire row to a new sheet.
Thank you for any help you can provide.
24162
In the example I've attached, the March data is currently populated with Vlookups from the pivot table. Can I use VBA to copy/paste just these cells based on matching the month, or is there a better way to move the pivot table values to the new spreadsheet without Vlookups? So far, all of the code examples I've found online have all been about searching through rows to find matches and then copying the entire row to a new sheet.
Thank you for any help you can provide.
24162