select only some sheets from a workbook through vba code so that reports can be got from those sheet

[rajavj]

hi to all experts here

i need to select only some sheets(excel) from the workbook programmatically(vba). the names of the sheets will be varying every day. but i have to select only some of the sheets so that i can get reports from those sheets. please can some one help in this problem.

 

[SkipVought]

Here's an example of a PivotTable on Sheet1. It only refers to the SkipVought sheet, that also contains a BOS column for your sheet name.

I removed all your code. It was voluminous and pretty much useless.

There is very little VBA in this version of your workbook. Some code to FORMAT the PT and remove unused PivotItems.

You can use the BOS dropdown list to select the sheets you want to display. Its that simple.

EDIT: I think that I also do a PivotTable REFRESH in the SheetActivate Event.

As combo stated in his last remark,

and easier responding to changed expectations of managers.

Maybe you don't know it now, but historical data is a precious commodity. Maybe you even have data from years previous on paper or in files somewhere. Sometime in the future, someone might ask a question or have an interest in knowing information about what rice production was happening in the past, maybe to compare to the present. All that data in one database (could be one table or a group of inter-related tables) and you'll have that data all ready to answer OTHER questions than the one you're answering at this time.

In fact combo may have a neater, slicker way to do this with Power Queries that I'm just not up on. But the basic "trick" is to have ALL your data in one table. Otherwise, you have a very limited and shortsighted solution that Excel is not really designed to handle easily.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein