Running a function in a loop and changing parameters
1 view (last 30 days)
Hi, i have a function that takes a text document, an excel document and a cell location in another document to add information in a master sheet on a specific line. This function is going to be run hundreds of times and rather than the user change the files to access and the cell in which to add the output to, i'd prefer for it to be automatic.
The files can be named '1.txt','2.txt','3.txt', '1.xlsx' etc. and the first cell of the master document to write into is A3. so when the function 'class' is running from 1 to 100 say, i need it to access the point in the loop and change the file names and the cell appropriately.
Cheers in advance!