Change single element of formula across multiple cells at once

[theonlyhamish]

I have a getpivottable formula across 300 rows of data.

It is designed to make a dashboard for managers that dont like looking at pivot tables.

The formula displays a number of criteria in a table showing the months of the year etc but there is one criteria that needs to change every 12 rows 'person name'

=IFERROR(GETPIVOTDATA("Date of Audit",'pivot tables'!$A$4,"Person","John Smith","Month",10),0)

is there a quick way to edit 12 rows at a time or is this going to be a row by row typing job?

Thanks

 

[bobaol]

Hi Alan the procrastinator, will you please share some images of your data? If there is a look up column of all the 'person name', AND the data changes exactly every 12 rows, it is easy to do with a copy/paste macro. but if your rows vary, then it gets a little harder. Still copy/paste will work fine, but you will want to have some criteria to lookup against. Cheers!

 

[theonlyhamish]

Hi, Thanks for replying. I simply used find and replace. It worked perfectly