Thanks Skip, unfortunately I am not a VB expert. Can you plse give me a quick example? Perhaps one that takes the results and puts them in adjacent cells?
Thanks
Vince
Hi
I have a List Box control on my worksheet with 'Multi' selection type, and I would like VB code to return the values selected.
Please note that the control is on the worksheet, not in a user form (I've searched for a solution but the only ones I've seen refer to list boxes on user...
Eureka! Figured it out.
Using the example:
=SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3))
To accomodate ALL Hubs when cell L1 is blank
=SUMPRODUCT(Mth*(Product=$A38)*(Hub=if(L1="",Hub,L1))*(Measure=L2)*(Type=L3))
and so on and so forth for any other conditions that may...
...sumproduct, just adding to its functionality, and not enough time to overhaul the structure unfortunately).
Using the example:
=SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3))
To accomodate ALL Hubs when cell L1 is blank...
...row and col headings etc.), which with Dsum would require lots of hidden criteria ranges
Basic/cutdown example of my problem:
=SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3))
Sometimes the variable references (e.g. L1 for Hub) return blank in cases where users want to see...
Basic/cutdown example of my problem:
=SUMPRODUCT(Mth*(Product=$A38)*(Hub=L1)*(Measure=L2)*(Type=L3))
Sometimes L1 (Hub variable) will return blank in cases where users want to see the combined result for ALL hubs...same for Product, Type etc.
If anyone has any ideas would be appreciated.
Thanks!
Thanks, I tried to stay away from Dsum, as each row in my tables has different criteria (based on user input form, row and col headings etc.), which with Dsum would require lots of hidden criteria ranges, sounds similar to yours. Tried searching everywhere for a Sumproduct solution but to no...
Hi, I have this exact problem too, and prefer sumproduct as the table structure needs to remain static (as opposed to pivottables) for charts. Anyone have any ideas or solution?
Thanks
Hi
We automatically receive emails when we make sales from a NZ auction site (similar to Ebay). The emails notify us that we've made a sale and include the email of the buyer WITHIN THE TEXT of the email. We use MS Outlook 2002.
Question - does anyone know of some sort of macro or rules...
Hi
We automatically receive emails when we make sales from a NZ auction site (similar to Ebay). The emails notify us that we've made a sale and include the email of the buyer IN THE TEXT of the email.
Question - does anyone know of some sort of macro or rules addon that could search those...
Hi
I have 2 tables:
1. GL account (which shows GL account number, name and account type etc.), and
2. GL Entry (values posted to GL accounts).
GL accounts in GL account table with an account type of 4 are totalling accounts. I created a query which shows the range of accounts they should...
Solved it (thanks to Larry De Laruelle)..simple too, dang! Future ref for anyone else:
"I think we may be back to size. What is the height of the subform on the tab?
If it is larger than the available screen space, Access will scroll down automatically
on load (or so it seems to me)...
Hi fwatanabe
The only difference between this form and the others, is that the subform on this particular page has 2 subforms within it (i.e. 2 subsubforms).
And it only happens when this when the fields in the subform of this tab control page are populated (i.e. when i'm adding a new record...
Hi fwatanabe
The only difference between this form and the others, is that the subform on this particular page has 2 subforms within it (i.e. 2 subsubforms).
And it only happens when this when the fields in the subform of this tab control page are populated (i.e. when i'm adding a new record...
hi there
i have a report with 30 subreports on it (in the detail section)...i want the first page of each subreport to start on a new page in the main report...do u know how?? (i've tried force new page in the subreport header/footer properties, but to no avail..maybe need to do something in...
I have a form that I want to show while a macro runs (i.e. busy message). Problem is, the macro won't start running until the use closes the form. Any suggestions PLEASE?
Thanks
The Blade
I've got a spreadsheet with 10 pivot tables (each on separate sheets)...below is a macro for updating one pivottable and moving narrative underneath it pending on whether the table expands/contracts...how can i loop it so that the macro does it for each of the 10 pivottables and then stops...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.