You could do a copy paste and then highlight all the formula and replace January_2019 with February_2019 (Ctrl + H)
Not that I know your data but if you could keep it all in a single table called Submitted_Forms and then add an extra column for Month to flag which entries are January , February etc then reporting would be easier via Pivot Tables or COUNTIFS
Hi Wyn, Thanks for the quick response. So I tried to do a replace January with February via the “find” function however it will not do it for some reason, it says the formula is wrong.
Re your other point re data on one table, I can’t use pivots (I think) because I need to manually choose which forms to group and this changes every now and then. Ie my collection using COUNTIF is based on form types/numbers that I manually choose, so I assume you cannot manual pick what to group in a pivot? And second would be re COUNTIF - I don’t know how to do two checks, one for the form and one for the date...? I assume that’s possible but may difficult due to number of lookups I do in one formula?