Hellow friends, I m using excel 2003.
I have Three sheet
FY0910
FY1011
SERIESWISE
I have data in Fy0910 & FY1011 sheet. In those sheet lot of data approx 20,000 row & nearabout 30 column.
In Fy0910 & Fy1011 : A column = invno, b column date, c column code, e column name, n column quantity, s column series, ab column month&date formula, ad column branch
Now i have calculate in serieswise sheet using sumproduct formula
and calculate data wise, series wise, customer code wise, also banch wise.
In Column F9 start date 01 Apr-09 to F374 row 31 mar 10 & H9 start date is 01 Apr 10 to H374 31 march 11. In column AD to AJ show as branch. In AD2 & AM2 type series, AD3 & AM3 customer code, AD7 to AJ7 branch of fy0910 & AM7 to AS7 branch of fy1011.
Now i calculate AD9 to AJ374 using sumproduct formula for fy0910 sheet calculation & AM9 to AS374 for fy1011 sheet calculate. I also used conditional formating if qty is > 1 display green & if qty is 0 then show as red colur.
My problem is when i need to change or edit series or select customer code, calculatation start very very very slow. It will take atleast 10 to 15 minutes.
Any other option to calcuate faster. Using other any option in same excel sheet or through vb. Please note that i m not familier with vb.
Secondly please let me know how to file attach in this tread. If sample file require.
I have Three sheet
FY0910
FY1011
SERIESWISE
I have data in Fy0910 & FY1011 sheet. In those sheet lot of data approx 20,000 row & nearabout 30 column.
In Fy0910 & Fy1011 : A column = invno, b column date, c column code, e column name, n column quantity, s column series, ab column month&date formula, ad column branch
Now i have calculate in serieswise sheet using sumproduct formula
and calculate data wise, series wise, customer code wise, also banch wise.
In Column F9 start date 01 Apr-09 to F374 row 31 mar 10 & H9 start date is 01 Apr 10 to H374 31 march 11. In column AD to AJ show as branch. In AD2 & AM2 type series, AD3 & AM3 customer code, AD7 to AJ7 branch of fy0910 & AM7 to AS7 branch of fy1011.
Now i calculate AD9 to AJ374 using sumproduct formula for fy0910 sheet calculation & AM9 to AS374 for fy1011 sheet calculate. I also used conditional formating if qty is > 1 display green & if qty is 0 then show as red colur.
My problem is when i need to change or edit series or select customer code, calculatation start very very very slow. It will take atleast 10 to 15 minutes.
Any other option to calcuate faster. Using other any option in same excel sheet or through vb. Please note that i m not familier with vb.
Secondly please let me know how to file attach in this tread. If sample file require.