Recent content by excelblackbelt

Thank you for your help.

Ok I did that reference. Now where does that go in the code?

Can I call you?

Sub Pool_Member() ' ' Pool_Member Macro ' ' Rows("14:14").Select Selection.AutoFilter ActiveWindow.SmallScroll ToRight:=4 ActiveSheet.Range("$A$14:$BN$426").AutoFilter Field:=13, Criteria1:= _ "Barna, Sandor" Sheets("2014 Merit Tool").Select Sheets("2014 Merit...

Can I do that with a macro?

Just did!

Hi Skip, Can I send you the master worksheet (w/o the data) that I have to be cut by pool manager? I need to copy out 35 worksheets and do not want to do it manually and it has to maintain the formulas. The Column header I need to cut off the master is called Pool Member (not country). Can I...

CODE Sub CuttingOutWorkSheets() ' ' CuttingOutWorkSheets Macro ' Dim r as range 'Assumes country list on Sheet2, list heading in A1 & table on Sheet1... With Sheet2 For each r in .Range(.Cells(2,"A"), .Cells(.Cells(2,"A").end(xldown))) With Sheet1...

Red = Issue that activity can't get done. Yellow = There is lag due to another stakeholder. Green = Activity is on pace to finish.

How?

Yes that's exactly the purpose. Sorry for the confusion.

This line is bad in the Debugger: [highlight #000000] For each r in .Range(.Cells(2,"A"), .Cells(.Cells(2,"A").end(xldown)))[/highlight][highlight #FCE94F][/highlight]

There is no text in the data validation list just colors

No Create a data validation list with solid colors that I can choose from to give a status on a project plan

Does anyone know how to create a solid color data validation list (without text)