Maliki Hassani
asked on
Excel: Code Modification to Count/Average to pull values in all sheets
Greetings Experts!
This question refers to a previous post that delt with Count/Average. The question was resolved by adding to the spreadsheet the following:
Sub UpdateCntAvgTable
Modification to Sub UpdateChart_ArrayOnLBLostF ocus
Added named range cPlotCntAvg
Added named range cPlotRange
Sheet "Executive Rollup Data" JG:KN we added a range that would populate values based on what is selected in the listbox.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---
I have duplicated this process (JG:KN ) to the rest of the sheets, like instructed. I am at the point where I need a way to have it populate the rest of the sheets and not just have the code looking at only the Executive Rollup Data sheet.
Currently, it is grabbing only what ID's are listed in Executive.
Need assistance on what options are out there to get this do be individually called.
Thoughts are that we need to create named ranges for all sheets like cPlotCntAvg and cPlotRange, but the VBA code still need to have a case statement to tell it to look at the name of the sheet to run a specific version of the UpdateCntAvgTable.
Please see attached file...
NOC-Reports-r26.xlsm
This question refers to a previous post that delt with Count/Average. The question was resolved by adding to the spreadsheet the following:
Sub UpdateCntAvgTable
Modification to Sub UpdateChart_ArrayOnLBLostF
Added named range cPlotCntAvg
Added named range cPlotRange
Sheet "Executive Rollup Data" JG:KN we added a range that would populate values based on what is selected in the listbox.
--------------------------
I have duplicated this process (JG:KN ) to the rest of the sheets, like instructed. I am at the point where I need a way to have it populate the rest of the sheets and not just have the code looking at only the Executive Rollup Data sheet.
Currently, it is grabbing only what ID's are listed in Executive.
Need assistance on what options are out there to get this do be individually called.
Thoughts are that we need to create named ranges for all sheets like cPlotCntAvg and cPlotRange, but the VBA code still need to have a case statement to tell it to look at the name of the sheet to run a specific version of the UpdateCntAvgTable.
Please see attached file...
NOC-Reports-r26.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER