automated form filling routine / process
I am trying to create a routine in excel where the information is retrieved from the database worksheet and this is subsequently processed x times into another worksheet with additional information which is different each time. I know it requires the use of a loop setup to replicate the data from the excel database, but I can’t seem to work out how to make it stop to allow me to input the additional data each time before it transfers to another worksheet to insert this data and save before repeating the process until it has completed the no of repetitions.
Each time it creates a form the heading will say recommendation y of x where x is the no of times it is repeated and y is the current value of x.
The data is mainly text.
Any help gratefully appreciated.
Regards
Colin
|