I am using Excel 2007. One sheet name is "data" & second sheet is "calculation"
In "data" sheet i have total 1,00,000 rows data.
In "calculation" sheet i have total 4000 rows to calculate (using sumifs formula)
My problem is its works slow & taking to much time for calculation.
In "data" sheet column "b" is invoice date, column "c" is code, column "n" is quantity, column "s" is series & column "ab" is month&date.
In "calculation" sheet i have column "a" code, column "b" customer name & from column "e" to "as" i calculate total sumifs with criteria code, month&date & series
I have attach sample file (with very less data).
I require vb micro for faster calculation.
Bookmarks