How to count number sheet with condition

[reimar_rem]

Hi,

Is there a way to count the number sheet with condition in a workbook? Like for example i want to count all sheet with starting name PO. I have attached file with desired output.

[TMS]

That's not really "counting" but, whatever, the only way I can think of doing it would be to use VBA.

[reimar_rem]

That's not really "counting" but, whatever, the only way I can think of doing it would be to use VBA.

Yeah agree. I mean to Populate in the sheet.

[TMS]

Still need VBA. Is that what you want?

[reimar_rem]

That's not really "counting" but, whatever, the only way I can think of doing it would be to use VBA.

Yeah agree. I mean to Populate in the sheet. Thank you for the response.

[samba_ravi]

Create Name Manager "Work_sheets" by using =GET.WORKBOOK(1)&T(NOW())
then M2=IFERROR(INDEX(MID(Work_sheets,SEARCH("]",Work_sheets)+1,256),ROWS(M$2:M2)),"")
TRY THIS AND COPY TOWARDS DOWN
G5=IFERROR(INDEX($M:$M,SMALL(INDEX((LEFT($M$2:$M$47,LEN(G$4))<>G$4)*10^10+ROW($M$2:$M$47),0),ROWS($G$5:$G5))),"")
AND COPY ACROSS
find the attached file

as TMS said it is a VBA

[reimar_rem]

Still need VBA. Is that what you want?

yes. is it possible?

[reimar_rem]

Create Name Manager "Work_sheets" by using =GET.WORKBOOK(1)&T(NOW())
then M2=IFERROR(INDEX(MID(Work_sheets,SEARCH("]",Work_sheets)+1,256),ROWS(M$2:M2)),"")
TRY THIS AND COPY TOWARDS DOWN
G5=IFERROR(INDEX($M:$M,SMALL(INDEX((LEFT($M$2:$M$47,LEN(G$4))<>G$4)*10^10+ROW($M$2:$M$47),0),ROWS($G$5:$G5))),"")
AND COPY ACROSS
find the attached file

as TMS said it is a VBA

Thank you for this. But i have a question. can this file works on a free macro work book? as, I cannot see any VBA code.

[samba_ravi]

It will not works but you can to the following

After getting the sheet names with the above, you need to copy the sheets names and paste them as pastespecial > values

[reimar_rem]

It will not works but you can to the following

After getting the sheet names with the above, you need to copy the sheets names and paste them as pastespecial > values

Thank you for the answer. I need it dynamically so I will use with macro enabled.