Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum value from multiple worksheets
I wish to use a macro or function to activate the cell with the
maximum value. As many as 25 worksheets are involved. Each worksheet will have a row selected. Any suggestions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum value from multiple worksheets
this may seem too obvious but why not create a summary page that has al the rows from your 25 worksheets and us the max function -- rmc544 ----------------------------------------------------------------------- rmc5446's Profile: http://www.excelforum.com/member.php...fo&userid=1600 View this thread: http://www.excelforum.com/showthread.php?threadid=27475 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum value from multiple worksheets
"Brian Allen" schreef in bericht om... I wish to use a macro or function to activate the cell with the maximum value. As many as 25 worksheets are involved. Each worksheet will have a row selected. Any suggestions. Use a macro to grab all maximums from all sheets to collect them in an array, or even in a 'dummy sheet' if that's easier. After that, get the maximum from your new collection. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum value from multiple worksheets
rmc5446 wrote in message ...
this may seem too obvious but why not create a summary page that has all the rows from your 25 worksheets and us the max function? I have to activate the cells with the ten highest values and alter them. It is possible that the ten highest values out of 2024 may all be on the one worksheet. So I need a method to store all the values (2024)and then activate the ten cells that contain the highest values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Tabs/Worksheets in a workbook? | Excel Discussion (Misc queries) | |||
Is there a maximum of the number of worksheets in a workbook? | Excel Discussion (Misc queries) | |||
Maximum number of Worksheets printed | Excel Discussion (Misc queries) | |||
Maximum number of worksheets in XL | Excel Discussion (Misc queries) | |||
maximum number of worksheets | Excel Worksheet Functions |