LinkBack URL
About LinkBacks
I need to write a User Enquiry function which will allow Users to select from a number of criteria and the result will total data from a number of sheets (around 40). I have attached a sample and I'm grateful for any ideas.
I need to write a User Enquiry function which will allow Users to select from a number of criteria and the result will total data from a number of sheets (around 40). I have attached a sample and I'm grateful for any ideas.
Last edited by BRISBANEBOB; 05-05-2009 at 07:01 PM.
Re: Excel enquiry over multiple sheets
Hi,
Can you elaborate a little more on your query?
--Karan--
Hi
I need to be able to sum all the values if a User completes any number of fields in the query. For instance, if the User might enter 2 in the Data Group and that would need to total all values by Quarter for anything which is part of Data Group 2. If they entered 2 and 3 in Data Group it would need to sum all values for both those Data Groups. If they entered Data Group 3 and Process from 17 to 25, it would need to sum all the values for those criteria!
Not easy...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks