Copy entire row from master sheet to corresponding sheet based on cell value

Hi ,
Here is what I'm trying to achieve :
I have all database on Sheet1 . Now based on value in column D (team) I'd like to copy entire row from Sheet1 to corresponding Sheet number. For example if the value is 1 in the column D then entire row gets copied to sheet 1. If the value is 2 then entire row gets copied to sheet 2 and so on. On top of that all copied rows should start from cell "A10" on their corresponding sheets. Please see attached file. The code i have there works fine but with small amount of data. I'm planning on expanding that database and number of worksheets so I'm looking for faster and more efficient code. Please help.

Please Login or Register  to view this content.

cubangt,

Thanks, this helps but I'm still wondering if there is a more efficient way to write this code. I'm planning on adding 30 more sheets so that means i'd would need to add 30 more lines of code with IF and Then statements. In this sample i only have 4 sheets beside master sheet so the code doesn't look bad ( long) but once i add 30 more sheets (teams) then its too long...

No, that's not it. Basically I'm looking to replace this long code with too many If and Then statements(below) with short one :

Please Login or Register  to view this content.

Originally Posted by cubangt

That my bad, mis-read the ask.

That's the one ! Thank you very much.

Hi WernerZiegler123,

When posting code, please use code tags. Also, please do not fully quote another thread. It just causes clutter.