Hello everybody
I wanted a solution but unaware if possible or not since multiple files involved.
I want to run a code in a file in sheet1 where it reads all the .xlsm files in a
particular folder for eg C:\Records\
All the files have the same sheet name as Temperature.
It reads the numbers in the range H8:M9 in all the sheets and list the numbers
in sheet1 in column A2 onwards where same numbers are not repeated and from
B2 onwards how many times that number has appeared. Like

A2 B2
11238 6
998 2
8876 1

etc...

I hope I am clear

Thanks
GKT