Summing data column with 3 to 4 criteria in summary, from excel2007 multiple sheets

[atulkhandekar]

Hi Friend's, I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly.
Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013.
In all above sheet :
Part numbers mentioned in column "C2:C60000"
Quantity in column "D2:D60000"
Branch in column "G2:G60000"
Month in column "H2:H60000"
Year in column "I2:I60000"
In some sheet record range in differ. Some sheet upto row 50000 & some sheet upto 38000 but field name partnumber quantity, branch, month & year in same column.

1st case : In recorder sheet i have calculate how many quantity sold part number wise as well as in particular year & branch wise. (Location of part number in A2:A10000 column & Year mention in column F2:J2 (i.e. 2009, 2010,2011,2012, 2013)

2nd case : In column L2 mentioned year (i.e. 2012) & L2:Q2 mentioned branch.(i.e. "HGN", "NGP", "AKL", "AMRT", "CHN", "YTMAL")
How many quantity sold branch wise in 2012 year.

3rd case : In column R2 mentioned branch (i.e. "HGN", & R2:W2 mentioned years 2009, 2010, 2011, 2012, 2013)
How many quantity sold from one branch in year wise.

In monthly sheet i have calculate how many quantity sold part number wise as well as in particular month & year wise.
In monthly sheet location of :
Part number in : "B1" cell.
Months : 1,2,3 ... so on upto 12 in location is B2:M2.
Years : "A4:A8

Presently, i have calculate through excel formula but calculation is slow due to thousand of data records
& thousand of formula. And it will take very long time.

Now i required to calculate through vba micro to speed up our work.
In view of the above kindly let me know.
Note: I am not familiar with VBA.

[Rabbit]

Have you thought about using a database instead?

[atulkhandekar]

Our database record in sheets "FY_2011" & "FY_2012". I have to calculate in "RECORDER" & "MONTHLY" sheets by using VBA micro for calculation faster instead of using formula in those sheets.

We have attach file for your ready reference. Please go through as per attach file.

[Rabbit]

As a rule of thumb, I do not download files from people I don't know.

Also, that's not a database. That's a spreadsheet. A database is Microsoft Access, or SQL Server, or MySQL.

[atulkhandekar]

I have attach micro soft access data record file.

[Rabbit]

As I've said earlier, I don't download files from strangers.

Instead, please describe the steps you've taken in the Access database to attempt to resolve your problem along with the code you used.