Passing data to Excel function

[PetrBr]

Hi, I got code generator programmed in Excel and I would like pass different data to these same functions (similar like calling function with arguments).

For example I have this simple generator and I would like to pass different data to Input1 and Input2 from some textlist.
{8C9AF32A-D224-4A9D-ADE5-ECDE460B7D8B}.png

I could just copy it numerous times, but it would we too time consuming and also if I need to change code, I would have to change it in every function.
{4D67590B-C1FC-47C7-B25D-FFE7F8E67192}.png

Can you point me to direction, which I should take? Thanks

[Richard Buttrey]

Hi, and welcome to the forum.

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length, different permutations or different sized ranges and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

That said if the original data is in A1:C3 why not just enter in A4

=A1

and copy that down as far as you need and across to column C

[PetrBr]

Hi Richard, yes I understand that it's very simplified example.

I already found pretty decent way how to do it. I just made simple macro, which copies source data to generator sheet, then copy the results to output sheet. All done in For loop.

{87A40B86-7330-49FC-A4D6-C33EE1D85DF6}.png