Hello there,

I am working with a large collection of data so I have attached an example where I have only left an example amount of data in but you get the idea. In the actual file there are around 2000 rows.

So what I want to do is to have an identical table on the second sheet but with a formula applied to each of the cells containing a number. The formula would be simple as it is just "3 - x" where x is each of the numbers in the massive table and they would be in their respective positions in this new table on the second sheet.

Usually I would simply set up a "=Sheet1!C6" type of formula and use the formula dragging thingy to apply it to all the other cells in the table but this obviously doesn't work when there are merged cells involved throughout the table. I don't think I can easily remove the merged cells because there are so many (nor would I want to). So is there any way I could set up a macro to set up a formula as stated above but do it for each non-merged section in the table. I.e. a macro that does something then moves 20 rows down and repeats it continuously until a set end point?

Many Thanks,

Chris