Hello all,
I have been on this thread a lot reading and learning formulas and VBA codes but I have one that I am stumped on and cannot find a common thread to learn from.
I have a workbook with sheets that start and are named as "Stage 1" and go on to "Stage 50".
Each sheet is identical with a row of data that collects on A143:AZ143. (A143 Being the number of the stage ex. (1) for stage 1).
With these I am looking for help building a vba code that ask what stage number you are trying to find and then paste the row from the stage sheet on the totals sheet over the numbers counting down from A9 and on to A59 for the 50 stages.
There are other sheets I need to link to as well but I feel if I can get this code down I can link it to the other totals sheets in similar form.
Thank you for any help,
Nate
I have been on this thread a lot reading and learning formulas and VBA codes but I have one that I am stumped on and cannot find a common thread to learn from.
I have a workbook with sheets that start and are named as "Stage 1" and go on to "Stage 50".
Each sheet is identical with a row of data that collects on A143:AZ143. (A143 Being the number of the stage ex. (1) for stage 1).
With these I am looking for help building a vba code that ask what stage number you are trying to find and then paste the row from the stage sheet on the totals sheet over the numbers counting down from A9 and on to A59 for the 50 stages.
There are other sheets I need to link to as well but I feel if I can get this code down I can link it to the other totals sheets in similar form.
Thank you for any help,
Nate