Copying rows from Master sheet (sheet 1) to mulitple sheets 2-13 based on value in column D of Master

[Ajones170]

I am trying to copy rows from master sheet (sheet 1) to multiple sheets based on the value in column D.
EX. If column D value = 1577 or 1603 copy to sheet 2
If Column D value = 5047 or 6425 copy to sheet 3.
Suggestions without adding a button on each sheet????

 

[mumps]

Are those four the only values you want to use as the criteria for copying the rows? It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your Master sheet.

 

[Ajones170]

No I have multiple values. I cannot give the data due to privacy issues.
Here is what I need.

sheet	Code in column D
Sheet2	1603	4995
Sheet3	1573	6073
Sheet4	5015	5048	5058	6425
sheet5	1577	5030	5059	5074	5108	6176	8733
sheet6	1655	5067	8646
sheet7	5033	5035	6290
sheet8	5065	5025	5028	5060	6354	7126
sheet9	1605	7208
sheet10	5037	5043	1617	7197
sheet11	1607	5045	7805	3402	6238
sheet12	5071	1615	2766	4521	5472	2766	5468	5467	5473	5461
sheet13	5064	5048

 

[mumps]

Based on the data you posted, the row with code 1603 would be copied to Sheet2, the row with code 1577 would be copied to Sheet5 and the row with code 5064 would be copied to Sheet13. Is this correct?

 

[Ajones170]

Based on the data you posted, the row with code 1603 would be copied to Sheet2, the row with code 1577 would be copied to Sheet5 and the row with code 5064 would be copied to Sheet13. Is this correct?

That is correct.

 

[mumps]

What column are the sheet names in? I assume that there can be multiple rows for any one sheet. Is this correct?

 

[Ajones170]

What column are the sheet names in? I assume that there can be multiple rows for any one sheet. Is this correct?

You can just call them sheet 2, sheet 3, sheet 4 etc. and then I can rename them

 

[mumps]

OK but I need to know in which column the sheet names are located.

 

[Ajones170]

What column are the sheet names in? I assume that there can be multiple rows for any one sheet. Is this correct?

There will be multiple rows that equal the value in D. Each row needs to be copied to the respective sheet.

 

[mumps]

Please answer my question: The data you posted in Post #3 shows that the code is in column D but does not show in which column the sheet names are located. In which column are those sheet names located in your sheet?