Hello all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I’m looking for some advice, suggestions or examples on how to proceed with this problem.<o></o>
<o> </o>
I need a column on a sheet to display the number of cells whose values in the source row exceed a value in Column B of that row on another sheet.<o></o>
<o> </o>
My previous post (http://www.mrexcel.com/forum/showthread.php?t=321207) dealt with 'highlighting' these values, now I would like to have these coloured cells counted for each row and the result displayed in a table on another sheet.<o></o>
<o> </o>
I have multiple sheets where the only differences are the row values in Column B (and therefore the coloured cells vary). <o></o>
Each of these sheets would have its own column in the ‘Totals’ table/sheet.<o></o>
<o> </o>
My spreadsheet has a 'front page' with all the navigation buttons on, the only button on the other sheets takes you back to the ‘front page’. This means there is only one button taking you to the ‘Totals’ sheet.<o></o>
<o> </o>
The way I see it, I have two options:<o></o>
<o> </o>
Option 1:<o></o>
Count all highlighted cells in row on sheet using a formula in the relevant column in the ‘Totals’ sheet, which is linked to a function.<o></o>
Pros and Cons: Won’t automatically update when source numbers change, but should be faster? Easier to incorporate multiple source sheets (by changing the cell formula in totals column).<o></o>
<o> </o>
Option 2:<o></o>
Write a macro to count cells in rows which are greater than or equal to and paste result into relevant row in table when navigating to the ‘Totals’ sheet using a button.<o></o>
Pros and Cons: Should auto-update (on button click) when source numbers change, but may be slow? Complex macro required to handle multiple source sheets?
<o> </o>
I’m erring towards Option 2 at the moment (as it relies on the source data rather than the formatting), but bear in mind that I have 3-6 sheets which contain the highlighted cells so don’t really want 3-6 different macros, which are all essentially doing the same thing…!<o></o>
<o> </o>
Any help (no matter how small) is appreciated!<o></o>
<o> </o>
Thanks,
<o> </o>
I’m looking for some advice, suggestions or examples on how to proceed with this problem.<o></o>
<o> </o>
I need a column on a sheet to display the number of cells whose values in the source row exceed a value in Column B of that row on another sheet.<o></o>
<o> </o>
My previous post (http://www.mrexcel.com/forum/showthread.php?t=321207) dealt with 'highlighting' these values, now I would like to have these coloured cells counted for each row and the result displayed in a table on another sheet.<o></o>
<o> </o>
I have multiple sheets where the only differences are the row values in Column B (and therefore the coloured cells vary). <o></o>
Each of these sheets would have its own column in the ‘Totals’ table/sheet.<o></o>
<o> </o>
My spreadsheet has a 'front page' with all the navigation buttons on, the only button on the other sheets takes you back to the ‘front page’. This means there is only one button taking you to the ‘Totals’ sheet.<o></o>
<o> </o>
The way I see it, I have two options:<o></o>
<o> </o>
Option 1:<o></o>
Count all highlighted cells in row on sheet using a formula in the relevant column in the ‘Totals’ sheet, which is linked to a function.<o></o>
Pros and Cons: Won’t automatically update when source numbers change, but should be faster? Easier to incorporate multiple source sheets (by changing the cell formula in totals column).<o></o>
<o> </o>
Option 2:<o></o>
Write a macro to count cells in rows which are greater than or equal to and paste result into relevant row in table when navigating to the ‘Totals’ sheet using a button.<o></o>
Pros and Cons: Should auto-update (on button click) when source numbers change, but may be slow? Complex macro required to handle multiple source sheets?
<o> </o>
I’m erring towards Option 2 at the moment (as it relies on the source data rather than the formatting), but bear in mind that I have 3-6 sheets which contain the highlighted cells so don’t really want 3-6 different macros, which are all essentially doing the same thing…!<o></o>
<o> </o>
Any help (no matter how small) is appreciated!<o></o>
<o> </o>
Thanks,