Copy data from one worksheet to multiple worksheets

[arvarr]

thread68-1803803

Hi Skip
With new requirements, I need to extend beyond 12 months.

Is there a quick fix to the code to cater to this?

Thanks,
arv

 

[SkipVought]

Hi,

My initial reaction as before.

You want to isolate data for a year/month so that you can sent it to some other party.

Why not simply FILTER your table on Year and Month, SELECT the table, COPY and then do whatever you need?

There is no need to process your entire table month by month to separate sheets!!!
There really is no need to put each month in a different sheet! Keep it simple.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[arvarr]

Hi Skip
The purpose of separating sheets is because there is a need to import the data in the ERP system mth by mth.

Thanks,
arv

 

[SkipVought]

...and a filter cannot segregate that data?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[arvarr]

Hi Skip
The import can only happen by separated worksheets.
All good now. I managed to reuse your initial code to extend beyond the 12 months by making some minor adjustments.
Thanks,
Arv