I apologise in advance if this is a glaringly obvious question, but I'm rather inexperienced when using macros.
I have written the following macro to automatically calculate/read a series of values into a new blank row.
This works for the cells specified in the code but I need to repeat this process for multiple blank rows throughout the entire data-set i.e. I need to do the same thing 4 rows later, the another 4 rows later etc.
What changes can be made to the code to make this happen. Is it even possible... or do I just have to re-write the code adjusting for the new cell references for every 4 rows?
Many thanks.
P.S. also as a secondary question I have the following macro for inserting a blank row, every 4 rows throughout the entire data set
How would I change this formula to insert a row every 4th row across a specified range of rows rather than across the entire data set?
Bookmarks