Hello,
I need a help with a small thing.
I am working on a project I am attaching the sample file as well as the macro enabled file.
My macro enable workbook will first ask user to open the excel file and when opened it calculate some data what i need here
when the 2nd userform pops up it asks user to type in the floor number (It is from column D in Demo file) if the user enters L2 it should show the total count of L2 in that sheet. For example in this excel file if the user enters L2 it should show there are total 12 L2 in a msgbox, if the user enters L3 application should calculate the number of L3 in Column D and show its count.
I have tried it but it always shows 0 and i don't know why.
Please help,
Thanks