In columns F to AB I have various data, most of this data is in a Range format.
This information is calculated identically for rows 4 to 32, differing
mostly on what data is present on other sheets.
In D10, I have the following =33-COUNTIF(J4:J32,0) showing me what line the
process stops.

I want a macro that initially uses the information in row 4, doing things
like.
Copy the value in H4, and on sheet J4 paste into a cell determined by AA4
(the value of which is "C4" currently) it will do several of these. The idea
being on the main sheet this information will change on a day to day basis,
but when the macro is run it will record it perminantly.

I've done this sort of thing before, with lots of copy and pasting of single
cells to get what I want. But i've never really worked with loops. And after
it has used all the information from line 4, I want to do it all again from
line 5, then 6, etc, unless the line is equal to the value in D10 when it
will stop.

Can you reset variables inside a loop using the loop number in a
Range().Value ?
Any help even if not a final answer will be appreciated. Thanks