Hi,
I am new to this forum and would really appreciate some help with a spreadsheet I am working on,
I have copied the two sheets onto a new workbook and uploaded it to here: Problem.xlsm
All the info on 'Sales Demand 2' gets pasted into that sheet automatically each week,
Please Refer To 'Sales Demand 2' Sheet
You can see that in Column A, BD, DF, FH, HJ, JL, LN, NP, PR, RT, TV are Product Codes,
Column A consists of the 'master list' of codes (all the codes that appear in Columns BD, DF, FH, HJ, JL, LN, NP, PR, RT, TV do appear in Column A)
The product codes in Columns BD, DF, FH, HJ, JL, LN, NP, PR, RT, TV are sub products of Column A,
The product codes in Columns A can appear more than once in each of the product code columns randomly (see example highlighted in yellow)
Please Refer To 'Sales Demand 3' Sheet
If you refer to the formulas between C2 and BB638 you can see that I am trying to get the totals for each week against the one instance of each code in the hope to getting a 'total demand' by week
This works and totals correctly but takes around 5 minutes to calculate, which is okay at this moment in time, but I have only input test data, hence why there are loads of '0's, so once the 'Sales Demand 2' tab becomes filled with numbers up to 7 decimal places I am concerned that it is going to be too slow to calculate a sales demand and deem the spreadsheet unworkable
Other Information
The programming I have written outside of this works in seconds and then this just takes forever and sometimes freezes when running with the other code,
I have set the 'Sales Demand 3' to enablecalculation = false and included with the workbook is a macro that turns it on and off so you can see how long it takes!
So what I am asking is... is there a quicker way to do this?
Many thanks
Jamie
I am new to this forum and would really appreciate some help with a spreadsheet I am working on,
I have copied the two sheets onto a new workbook and uploaded it to here: Problem.xlsm
All the info on 'Sales Demand 2' gets pasted into that sheet automatically each week,
Please Refer To 'Sales Demand 2' Sheet
You can see that in Column A, BD, DF, FH, HJ, JL, LN, NP, PR, RT, TV are Product Codes,
Column A consists of the 'master list' of codes (all the codes that appear in Columns BD, DF, FH, HJ, JL, LN, NP, PR, RT, TV do appear in Column A)
The product codes in Columns BD, DF, FH, HJ, JL, LN, NP, PR, RT, TV are sub products of Column A,
The product codes in Columns A can appear more than once in each of the product code columns randomly (see example highlighted in yellow)
Please Refer To 'Sales Demand 3' Sheet
If you refer to the formulas between C2 and BB638 you can see that I am trying to get the totals for each week against the one instance of each code in the hope to getting a 'total demand' by week
This works and totals correctly but takes around 5 minutes to calculate, which is okay at this moment in time, but I have only input test data, hence why there are loads of '0's, so once the 'Sales Demand 2' tab becomes filled with numbers up to 7 decimal places I am concerned that it is going to be too slow to calculate a sales demand and deem the spreadsheet unworkable
Other Information
The programming I have written outside of this works in seconds and then this just takes forever and sometimes freezes when running with the other code,
I have set the 'Sales Demand 3' to enablecalculation = false and included with the workbook is a macro that turns it on and off so you can see how long it takes!
So what I am asking is... is there a quicker way to do this?
Many thanks
Jamie
