Input a range of values into a cell and return the values for each loop

[cavalieregiuseppe]

Hi,

Say if I have a range of values in A19:A119 and I want to input them into cell A17 and then I want the results of cells A11,A12,A13,A14 and A15 pasted into columns C,D,E,F,G how would I do this using a VBA style loop.

Cheers,
GC

[kersplash]

Attach a workbook that shows before and after.

Go Advanced -> Manage Attachments -> Upload

[YasserKhalil]

Please upload sample of your file with the desired output

[cavalieregiuseppe]

Hi Mate,

Attached as requested under Workbook Tab 3.

Regards,
GC

[YasserKhalil]

Try something like that

Please Login or Register  to view this content.

[cavalieregiuseppe]

Yeah this seems to be on the right track however I want it to run all of the values in A19:A119 at once and if that’s not possible when each value for A17 and the macro is run the results are entered in the row below not just replace what’s already there.

Try something like that

Please Login or Register  to view this content.

[YasserKhalil]

Can you attach some of your desired output?

[cavalieregiuseppe]

Never mind I have found a more optimal high level solution to my problem. Cheers for you help though.

GC

[YasserKhalil]

Glad you solved it .. I think it will be better if you share your solution