Search results for query: *

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)

I got a compile error...

Hey Skip, Here you go... Sub CuttingOutWorkSheets() ' ' CuttingOutWorkSheets Macro ' ' Selection.AutoFilter ActiveSheet.Range("$A$1:$FO$349").AutoFilter Field:=5, Criteria1:= _ "China-Yuan" Cells.Select Selection.Copy Sheets.Add After:=ActiveSheet...

The different sheets will be cut out by country for their respective information. I can copy the master file and with the copy divide using the macro...I hope this helped.

Well for the project I am working with now I have 15 columns of data that I need sorted by country and that has to be parsed out into individual worksheets by country. In the future I will have the same file with budgets attached to each country for each person. I just need the former Macro...

Hello: I have a worksheet that I need to breakout by location into separate worksheets. Does anyone know of a macro that does this? I don't want to have to copy and paste every single country out into new sheets. I am working with 12,000 rows of data. Also, if I am maintaining budgets in these...