Count filtered data in VBA referencing multiple columns in a table

**tila11523** · 03-02-2016, 12:51 PM

Hello again. I am having a hard time figuring out my problem. I hope I can explain it well. Basically I am trying to set my integer to count filtered data in a table. I have 7 columns of almost the same data that I want it to look at looping through each one. Ex. columns: Level 1 Manager, Level 2 Manager, ...., Level 7 Manager. I tried this code hoping for something but it is giving me a Compile Error: Sub or Function not defined on the first ROW statement.
Example code

Please Login or Register  to view this content.

I had a countif in there previously before I found out that the Countif counted all data including the unfiltered data. I have x = 1.
I want to say IF mgr >0 Then... Else End IF
Also, I want it to reference the name that is selected from a drop down cell on another tab (that is where the "Sheets("Report").Range("Manager") comes from. I am not sure this is possible but I know there are some extreemly smart people here that can give me some kind of direction.

**walruseggman** · 03-02-2016, 02:13 PM

First, the Syntax is Rows(), but inside the parenthesis needs to be a whole, greater than zero number, not a range object like you are trying to use.

That being said, you really should post an example workbook showing what you are trying to achieve.

**tila11523** · 03-02-2016, 02:54 PM

Ok attached is a sample workbook. On the Report page, Generate List is supposed to paste data from the data page of certain columns of whoever is labeled in the Select Manager drop down. My problem is when it is filtering, the mgr= integer is counting all data in the column and not just the filtered like I need it too. I need it to loop through each Level "*" column and paste on the Report tab.