cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Input Output in to Excel using a loop

ptc-5377589
Newbie

Input Output in to Excel using a loop

I want to be able to read a known number of multiple input values from one excel sheet and populate the corresponding multiple outputs in another worksheet Those outputs will be a mix of values and text. To do this I assume I need a programming loop. I have a complex worksheet but can someone show me how to do with this in principal with this simple example ?

G

2 REPLIES 2

Re: Input Output in to Excel using a loop

Something like the attached?

Alan

Re: Input Output in to Excel using a loop

As a start, as Alan has done, you need to set the Output range within the embedded Excel component. Then you can work from there.

Announcements