VBA to shift range of formula down 19 rows

[dpsersimon]

Hi Guys,

If you guys could help I would be SOOO happy, this will take me ages to do manually

I have a whole range of cells that reference one data source on another sheet. The data the range is referencing is user input data and needs to be in a non excel friendly format. When users input that data it is repeated every 19 lines.

What I would like to do is shift down the range I have already set up down 19 rows (I would do this manually but it is repeated 14 times and there are a lot of formula to change). Any one know a macro that could do that?

Also I have tried the offset function but because they are not straight cell references it won't work.

So to recap I would like a VBA that just add 19 to each number in the range of formula then copies it below. I have attached a work book with an example of the data I'm working with. Book1.xlsx

[skywriter]

Your formulas are linked to a file we don't have, therefore what we see in the formulas is probably not what you see because of the references.

The cell references I can see in the formulas are not row absolute references, so the formulas can be easily copied down, therefore I don't get what you want and why.