[SIZE=14px]Hi!!!
I have a excel workbook in which there are 1000+ sheets which are increasing. Now [/SIZE]I need to get total value of column "I" (Range "I7:I") for all sheets based on month (from date) in column "F" (Range "F7:F") where column "F" is date column in messagebox.
Example: If I want to check the data for the month of February, 2018 in entire sheet then it will calculate the sum the values from column "I" and show it through message box.
Help required.
Thanks in advance.