Looking for help

[VinceB]

I am trying to figure out how to get a specific row in an excel spreadsheet to automatically be entered into another worksheet (in the same workbook) by using a specific condition.

My example is this:

I have a sheet named Master list - which has all the information. The fields in column G (District) would be the value that would automatically insert that particular row in the corresponding worksheet:

If the Districts are Northern, Southern, Western, etc...The row that has that particular District name would be inserted into the WOrsheets named Northern, Southern, Western, etc.

The master list would be the list that would be changed, but would reflect in the other worksheets.

 

[VinceB]

I am using Excel 2003

 

[Peter_SSs]

Welcome to the Mrexcel board!

See if this thread is any use.

 

[VinceB]

I was hoping to do without using a Pivot table or Macros. I do think I found an older post that the solution is similar to what I want to do.

 

[VinceB]

I think I got it, I found an older post that is working beautifully.

 

[Peter_SSs]

I think I got it, I found an older post that is working beautifully.

That's good, but note that the link I provided above was also a suggestion without Pivot Table or Macros.

 

[VinceB]

Is there any way I could have the checkboxes also be copied from the master sheet to the corresponding sheets?

 

[VinceB]

I also want to do this:

have the rows be a certain color when a specific column has a specific term - I can do it using conditional formatting, but I am limited to 3

 

[Peter_SSs]

Is there any way I could have the checkboxes also be copied from the master sheet to the corresponding sheets?

I also want to do this:

have the rows be a certain color when a specific column has a specific term - I can do it using conditional formatting, but I am limited to 3

You should be able to do both of the above but you would have to relent on the following:

I was hoping to do without ... Macros.

 

[VinceB]

that was my thinking, I had a feeling macros would come into play. Also, I have upgraded to Excel 2007 (go figure) so I am more interested in getting the checkboxes copied than the colors