I am working on a project and first step was to count the number of floors in a particular user enters in the textbox
now i want to check if its is (DSC, DSC-ED, DSC-FA) (DSC, DSC-ED, DSC-FA these are same just different names) or (DSC-ERV, DSC-HRV and this both are same as well just different names) from column I for the each entered floor
what i mean here is if the user entered L2 it shows me the total count of L2 in a particular sheet now i want to check for each L2 weather it is (DSC, DSC-ED, DSC-FA) or (DSC-ERV, DSC-HRV ) from column I and then display the total number of DSC and total number of DSC-ERV in that floor. (DSC-ED, DSC-FA comes under DSC so you can count them or treat them as dsc) (DSC-HRV comes under DSC_ERV so you can treat it as DSC-ERV)
I have attached the file i am using.
Demo Manufacturing file is the demo excel sheet and Manufacturing breakdown is the macro enabled sheet.
If you can please help me with this?