You'll want to COPY VALUES ONLY from cells K4167:Z4167 each time it changes.

Then PASTE SPECIAL VALUES to the first empty in a blank worksheet. Paste to A1 to begin with ... the code will do the rest.

When ready, you'll have a table of data to view.

Google for examples for the terms in bold. Tons of examples to review.

Thanks, Logit. If I understand correctly, you are suggesting manually changing the independent variable and then manually copying and pasting the output to save it? If so, that is practical for a small number of cases. But I have many hundreds of cases to test each, on a number of different variants of the basic worksheet. So I am looking for an automated solution.