Getting a list of Sheet Names by excluding certain Sheet Names instantenously..
Dear Forum,
I need to get the Sheet Names of all the Sheets except a few Sheets viz the Parent SHeet in which these Names have to be displayed and also 1 or 2 Additional Sheets..which are not required to be included such as Sheets which are required to store Data Validation Elements and other information but not meant for the specific operation of the Sheet Names Data to be added.
Example:
Total\100\105\List1\List2\141\32
Now as seen above there are 7 SHeets in all and from the 7 Sheets I want to actually work only from the Sheets which are 100\105\141\32 and this list needs to be shown in the Range from O2 till whatever "O"RowNo till SHeets are added..
So Now it will be just O2:O5 FOR 4 Sheets.
I want this List to appear instantly as and when any NEw SHeets are added or removed, but I also dont want to include 3 Sheets one is the Parent SHeet where the List is to appear that is the SHeet "Total" and the other Sheets are List1 and List2.
So, Preferably, I dont want to mention the Name "Total" as this Name if changed the code should not cease to work some Active.Sheet Fundaa can be used but for other Sheets i.e List1 and List2 I can explicitly mention them somewhere in the code which I get as HELP.
OR Have a List of NON-Required SHeets OR maintain a pattern that the Sheets which are not reuired will start as NON-List1 so we can tap the word "NON"
SO, please allow these changes to be incorporated in the VBA code so that in future too I can add any SHeets such as List3 and still not include them in the list and more importantly this has to be instantenous as there are certain NON_VBA approaches which give the List but do not update immediately..
Warm Regards
e4excel
Bookmarks