VBA Help need for Copying data from another sheet and create separate sheets

Folks,

I have a workbook with two sheets the first one is called "SDL" contain master data for three TEAMS (TEAM.A, TEAM.B & TEAM.C") and the second worksheet is called "SDL_Calendar" for graphical chart view.

I need Macro to copy the relevant column data from "SDL” sheet and paste into appropriate column in "SDL_Calendar" sheet then make separate sheets for each “TEAM".

Thanks to Mr. John (jaslake) and Mr. Johan (berlan) who helped me by developing some macros to setting the workbook up to this stage.


I have attached the work book of what I am trying to accomplish.



Thanks in advance.

Joshi

Hi Joshi

Try this Code in the attached

Please Login or Register  to view this content.

Hi John,

Thank you so much, excellent code. And have some minor issues please help me to fix.

1. For the testing purpose I deleted “TEAM.A” worksheet then I rerun the Macro, but the “TEAM.”A worksheet was created without data.

2. The “TEAM.A, B & C” worksheet’s row height and column width should be same as “SDL_Clendar” worksheet

3. If I add new row data in “SDL” worksheet for any one of the TEAM that also need to be copied into “SDL_Calendar”. And the new copied data to be formatted same as above row format including row heights & cell border; then the new added data to be reflected in the relevant TEAM sheet also.

4. “SDL_Calendar” Column "C:D" getting blank. That to be filled, Column "C:D" values = "P:Q" values

Thank you so much once agian for your time and support.

Joshi

Hi Joshi

For this issue it's a lack of Dots(.)...add them as indicated

the “TEAM.”A worksheet was created without data

Please Login or Register  to view this content.

The other issues, I'll need to look at...it'll be a while...

Hi Joshi

These issues have been dealt with:

1. For the testing purpose I deleted “TEAM.A” worksheet then I rerun the Macro, but the “TEAM.”A worksheet was created without data.

Code has been rewritten in part...Fixed in rewrite

2. The “TEAM.A, B & C” worksheet’s row height and column width should be same as “SDL_Clendar” worksheet

Code has been rewritten in part...Fixed in rewrite

3. If I add new row data in “SDL” worksheet for any one of the TEAM that also need to be copied into “SDL_Calendar”. And the new copied data to be formatted same as above row format including row heights & cell border; then the new added data to be reflected in the relevant TEAM sheet also.

This issue has been dealt with as follows:
Part 1...Add as many rows as you like to the SDL Calendar Sheet...format them as you like...fill the entire Sheet if you like.
Part 2...Simply rerun the Code...SDL Calendar and Team Sheets will be rebuilt to include the added items.

4. “SDL_Calendar” Column "C:D" getting blank. That to be filled, Column "C:D" values = "P:Q" values

Code has been rewritten in part...Fixed in rewrite

Please Login or Register  to view this content.

Hi John,

Excellent code, its working like anything. I problems are solved. Thank you so much for your time and help.

YOU ARE A REAL GURU.

Thanks once again.

Joshi

You're welcome...glad I could help. Thanks for the Rep.