Search results for query: *

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...

SumProduct with a wildcard. I have some criteria that may be blank, in which case I don't want them included in the SumProduct at all. The forumlae are in a table, the structure of which needs to remain static (as opposed to pivottables) for charts. I am trying to stay away from Dsum, as each...

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...

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...

Hi there I have multiple sheets, and each one has a pivottable that feeds off a data dump worksheet. The data dump changes, and so when the pivottables are refreshed they expand/contract depending on what is in the data dump. Under each pivottable are labels/narrative, and I would like these...

I have a report with 30 fields per record (each has a numeric value from 1-5). What I want to do is calculate the total percentage of record fields that are <3. Anybody have an idea on the best way to do this in the report? it is difficult to do in a query, cos I'd have to specify criteria...

I created a macro to prompt synchronization, but it freezes (I assume because the macro object is still open). Does anybody know how this can be done? I have a design master and 3 replica's and ideally would just like to have 1 button for the users to push and all replica's would synchronize...

I am using multiple forms to enter records for a table (the table has too many fields for a single form - the reason for having multiple forms). The problem occurs when I open the 2nd form, it goes to a new or different record. Does anyone know how I can synchronize the forms so that they work...