VBA for repeating a calculation and pasting a value-only list of inputs/outputs

So I have a single input cell (say D1) and a single output cell (say D2). I would like to make a table of pasted values for a range of inputs/outputs in the range A1:B100.
I'm guessing this would be something using a For...Next loop (For i = 1 to 100) but I'm totally new to VBA and don't know how to write the macro.
Any help would be very much appreciated. I hope I've explained the problem well enough!

Hi HanJam,

Welcome to the forum

It is possible a loop is the best approach, but that all depends on the logic of how the cells are populated. It would be ideal if you can provide a sample workbook, doesn't need real data, but it should represent the format/content of the real data.
Provide before/after samples, and the logic behind it.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

So, what you want to do is record values in D1 & D2 for each time value is entered in D1.

Then out put to A1:B100 range?

Then there is no need to do loop. You will just need to trigger the code each time value in D1 changes.

Ex:

Please Login or Register  to view this content.

The code would not be in a normal module. In the vba editor, double-click the name of the sheet where the code should trigger, and put it in there.

@CK76, nice job understanding the requirement

What Arkadi said

But, note that code will start data entry at A2:B2. A1:B1 is reserved for headers.

See attached sample.