Search results for query: *

Guys that is genius. Thanks both for your help. I thought I knew Excel quite well - just goes to show! The more I see, the better it gets!!! Thanks again B.M.

OK. Ideally, I would like a function that will generate me a single total sales figure for the week commencing, based on a user-input cell Data table looks like (lets assume the Date label is in cell A1 - I will input the date I need into cell Q1). Date North East South West 1/1...

skip, will your solution work with multiple columns? Is the date range just the date col, or date col + data? B.M.

thanks B.M.

Single figure. Think I could probably knock together 7 figures B.M.

Cool, thanks. I'll try that now. B.M.

Hi all, Is there any formula will help me with the following query? I'm aiming to punch in a date and have a "vlookup" type function return sales figures for that date, plus the next 6 days. Thanks in advance. B.M.

Like duh, Excel 97 is so yesterday. It's not even supported by Microsoft anymore Try If Dir("T:\Apps Support\RELOGS\Call Analysis.xls") <> "" Then ' the file exists, returns "" (empty string) if the file doesn't exist. MsgBox "File Exists" Else MsgBox "File does not...

Zathras, the formula itself is solid - I've copied the formula into the worksheet and it works. The formula shown above is only looking up a value from a 3 row table for testing purposes. Skip, I'll check the variant and get back B.M.

Thanks Skip. Data is already a range. I tried with Application. and it generated a type mismatch. The holding variable contains "Error 2042". We're using Excel 97 if that helps B.M.

Hi all I had thought that using vlookup within a module would be fairly easy. I've got the code 'a = WorksheetFunction.VLookup("a", data, 2, False)', but I get an error message of "Unable to get the Vlookup property of the WorksheetFunction class. Am I missing something? Cheers B.M.

Wow, sounds more complicated that I'd expected, but I'll check into the openquery. Cheers B.M.

Hi all I have a database containing a list of members, and next of kin details. As you can imagine, most NoK share the address with the member. I've created a routine to copy the member's address details to the NoK subform, but can't dump the data. Does anyone have any idea how I can "copy"...

Absolutely brilliant, thanks very much for all of your help. If I get a payrise out of this, I'll thank you properly. B.M.

Remou, Is it possible to also include an ID field in this query, allowing me to synchronise the delegates to the date of their training? BM B.M.

Brilliant. Thanks very much B.M.

hi, I've "inherited" a database that's being used as part of a project, and have been asked to introduce a combo box listing all training delegates names, to prevent the mistyping of names we're currently experiencing. Easy, right? the catch is, the delegates names are in a non-relational...

Thanks for your answers everyone. I now have the system working. B.M.

Strewth - thanks a bunch Skip - I promise you I tried that before posting. Thanks again BM B.M.

Thanks for that Skip, I double checked the VB help and found some references, however the hlp file required hasn't been installed on my system (and there's no chance of it being installed soon). Do you know of a way of checking for a valid date? Thanks very much B.M.