Hi Everyone. Thanks in advance for helping me out.
I am making a Gradient Calculator for export. I need your help on how to create a code to automatically fill in the values between the "Top Depth" and "Bottom Depth" in increments of 1.
Example:
Top Depth = 5 (Value is in cell H3) Manually input by user on active sheet
Bottom Depth = 444 (Value is in cell I3) Manually input by user on active sheet
I am looking for a code that puts the "Top Depth" into cell B3 and then counts down to 444 in increments of 1. (Basically auto filling without dragging the cells)
In addition to this, I would like the formula in column C to auto fill down to "Bottom Depth" (I3)
Your time is appreciated.
Regards,
Hal