Hello,
Is there any way of making you macro move through sheets without having to call each one. I am wanting to run a loop that will take the info off a sheet, when it has gathered the info to move up 1 sheet and take all the info I need from there and loop until I run out of sheets [in this case there are 6 sheets]. It is just the moving up a sheet bit I need but I have run out of ideas on how to make this work. Please can you help.
Thanks
Is there any way of making you macro move through sheets without having to call each one. I am wanting to run a loop that will take the info off a sheet, when it has gathered the info to move up 1 sheet and take all the info I need from there and loop until I run out of sheets [in this case there are 6 sheets]. It is just the moving up a sheet bit I need but I have run out of ideas on how to make this work. Please can you help.
Thanks