There are 4 excel sheets in a workbook and every sheet has huge data i.e.
datewise productwise sales details
Now i want get the below details in 5th excel sheet i.e. total sales of
specific product in specific time by using VBA code as every sheet has atleast
4-5 lakhs data
Why i'm asking...