largeselection
Active Member
- Joined
- Aug 4, 2008
- Messages
- 358
Hello,
Basically I have an issue that is probably best served with a database. I have an excel sheet that is 1.5 million rows (spread across 20 tabs). I don't have access to a database program. I need to do something that would be simple with a pivot table, but I can't pivot 1.5 million rows across multiple sheets to my knowledge.
So I figured out a way I could get the answers I need using countifs.
The issue that I'm having is that I don't know how to define the ranges of all worksheets.
What I'd like to accomplish (VBA or otherwise) would be something like this: If the cell in column B (across all worksheets) = reference cell A3 and the cell in column C (again across all worksheets) = "<1" then count it.
I can do this in one sheet easily using countifs, but I don't know how to set the range as every column B in the workbook.
I know this is confusing, so please ask questions if you have any
Basically I have an issue that is probably best served with a database. I have an excel sheet that is 1.5 million rows (spread across 20 tabs). I don't have access to a database program. I need to do something that would be simple with a pivot table, but I can't pivot 1.5 million rows across multiple sheets to my knowledge.
So I figured out a way I could get the answers I need using countifs.
The issue that I'm having is that I don't know how to define the ranges of all worksheets.
What I'd like to accomplish (VBA or otherwise) would be something like this: If the cell in column B (across all worksheets) = reference cell A3 and the cell in column C (again across all worksheets) = "<1" then count it.
I can do this in one sheet easily using countifs, but I don't know how to set the range as every column B in the workbook.
I know this is confusing, so please ask questions if you have any