Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’ve got a 250 row querytable that constantly expands/retracts. On this table I’ve applied the autofilter function to be able to filter all projects in the list based on supplier, sales area etc. <o></o>
<o> </o>
What I want to do now is adding a summary on what is shown on the screen (by using the sumproduct function). I was thinking of putting this summary table on the right on my list since the end-user shouldn’t have to scroll down to the bottom every time and also I can’t think of how to solve it practically as my list expands/retracts all the time. The problem is that when I put it on the right side it will also be filtered since I don’t know how to “lock” these cells from being filtered. <o></o>
<o> </o>
Does anyone have a clue how to solve this or have had a similar problem?
Thanks so much for this great forum.<o></o>
<o> </o>
Best regards<o></o>
<o> </o>
Per<o></o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’ve got a 250 row querytable that constantly expands/retracts. On this table I’ve applied the autofilter function to be able to filter all projects in the list based on supplier, sales area etc. <o></o>
<o> </o>
What I want to do now is adding a summary on what is shown on the screen (by using the sumproduct function). I was thinking of putting this summary table on the right on my list since the end-user shouldn’t have to scroll down to the bottom every time and also I can’t think of how to solve it practically as my list expands/retracts all the time. The problem is that when I put it on the right side it will also be filtered since I don’t know how to “lock” these cells from being filtered. <o></o>
<o> </o>
Does anyone have a clue how to solve this or have had a similar problem?
Thanks so much for this great forum.<o></o>
<o> </o>
Best regards<o></o>
<o> </o>
Per<o></o>