How to reference to a specific sheet?

[aadeshgandhi]

Hello,
I know the title is not all that descriptive, I hope the explanation will help. I am trying to edit a macro that I have recorded earlier. This is first bit which I assume will work fine.

Please Login or Register  to view this content.

Now below this there are number of steps that clean the data in Sheet 2, once the data is cleaned I would like to paste it back into the sheet from where it was picked up and I do not know what that command would be. Can anybody please help me?

Thanks,
Aadesh

[BigBas]

Aadesh,

The question is a bit vague. You can set up variables for each sheet, and use those as the reference. For example:

Please Login or Register  to view this content.

DOes this help?

[aadeshgandhi]

Not really BigBas, I will try to explain it further.
Right now what I have this One sheet named SWES and then multiple sheets names SWIS 1, SWIS 2 and so on... In the present sheet, I have a macro that works fine when I run it on SWIS 1, SWIS 2 etc. So if there are 50 sheets the user had to run the macro 50 times. I am trying to minimize that to one by creating a macro that will loop through the workbook.

The code below is what I have now and it works fine

Please Login or Register  to view this content.

This is how I would like the macro to work
Macro should run from SWES sheet, it will then go to SWIS 1 copy the relevant data, paste and edit in Sheet 2 and copy back the edited data in SWIS 1. then move to next sheet.

This is code below that I have started to work on but do not know what should go in those ?????

Please Login or Register  to view this content.

I hope this helps.

Aadesh.

[Pichingualas]

Try with:

Please Login or Register  to view this content.

[aadeshgandhi]

Hi Pichingualas,
That did not work and I also observed that instead of copying the data from other sheets it macro copied the data from SWES sheet which should not have happened. Any other ideas.


Thanks,
Aadesh.

[Pichingualas]

Try this:

Please Login or Register  to view this content.