Collecting data from different worksheet in a single worksheet meeting certain criteria

[vikash]

Hi All,

I have 10 different worksheet, i want to collect the information in a new worksheet if they meet criteria of category being A or A+ in same format.

 

[srinidhi]

Hi Vikash,

What do you mean the same format, are referring to the font, its size.

 

[srinidhi]

Hi Vikash,
Please find attached the sheet, hope this is what you have been looking for. It has macros to combine all the sheets into a single sheet. Filter the data manually & the result's are pasted in the result sheet.

 

[vikash]

Hi Vikash,
Please find attached the sheet, hope this is what you have been looking for. It has macros to combine all the sheets into a single sheet. Filter the data manually & the result's are pasted in the result sheet.

Hi Srinidhi,

Thanks for your help. I had already done this. Basically what i was looking for was, "Is there any formula or method through which we can get the result without using VBA or doing it manually by filtering the data?".

Basically people like me who dont know how to write VBA need to rely on formula.

regards,
vikash