Hi I have an excel file with lots of tabs, now the column B of all the tabs contains SA or TA. Is there a way to generate a sheet with the tab name and the value of column B.
For example:
Sheet Value
TA001 SA
TA002 Both (As SA & TA are both present)
CO007 Both
TA009 TA
I am attaching an extract of my data for your reference.Please guide me,
thanks,me
If you have the sheet names in column A of your summary sheet, you could use this formula and drag down.
=CHOOSE(SIGN(COUNTIF(INDIRECT(A1&"!B:B"),"SA"))+2*SIGN(COUNTIF(INDIRECT(A1&"!B:B"),"TA")) +1, "neither", "SA","TA", "both")
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Amazing & perfect, thanks a ton mikerickson,
Can you kindly make a vba code do the same thing as the file is a system generated file and there are many sheets, and I don't have the summary sheet with all the names populated.
a vba code than can do the same thing will be a great help & also I can use it in future.
Thanks a ton ! :D Godbless
Any help thanks friends.
Last edited by fatalcore; 07-01-2012 at 06:24 AM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks