Search results for query: *

Hi Ken, The possible scenarios are:- Jan 101% Feb 103% Target 100% = up_good Jan 97% Feb 99% Target 100% = up_good Jan 103% Feb 101% Target 100% = down_good Jan 99% Feb 97% Target 100% = down_good Jan 107% Feb 109% Target 100% = up_near Jan 91% Feb 93% Target 100% = up_near Jan 109% Feb 107%...

Hi Ken, I have just realised I can't do what I want using this excel formula. As you pointed out at the bottom of your mail I have not covered all the possible scenarios, if I wanted to the nested if statement would have 12 if statements as it can be up_good twice e.g. jan 101% feb 103% and...

Hello All, Please can you help me to solve this problem. I have monthly %'s, in this case m19(e.g. Jan) = 88% and L19(e.g. Feb) = 104% and $R19 is my static target of 100%. If the % is within + or - 5% of the target I want to show the defined name of either down_good or up_good. down_good and...

Hi Skip, Yes I have checked that the table options has the grand total for rows and columns ticked, it just won't let me have these totals as a series. Any more ideas would be much appreciated. Thanks, Alistair

Hi, I am only used to Win97/2000 Excel and I am struggling with some basic functionality. When I create a pivot table I don't seem to be able to view the grand totals in my chart associated with the pivot table. Therefore, I can't run a grand total/trendline against one axis and all the...

Thanks ETID, I used that an put an application.wait to time the loop until the process has run within the OLAP tool. Thanks for your quick response. Cheers, Ally

Hello Chaps, I have the following problem: (1) I have an ODBC link to a database which populates a spreadsheet via parameter and refesh buttons on a VB form. (2) I then copy the populated section of the sheet to another sheet and then save it as a CSV. file. (3)The point of doing this is that I...

Hi, Perhaps if your header has a space or something you can put between the two sub headings then the following would work. You would need to put getStrItem(strData, iPosition, strDelim) in the relevant cells where you wanted the split, strDelim is "_" or "." (to split the...

Mike, Cheers for the advice I will try this to see if it helps me shorten (tidy up) my code --- much needed. Thanks, Alistair [thumbsup]

Hello chaps, Sorry to butt in - if this thread is till running.I have been working with what I think it is a similar situation, perhaps you may find this interesting amd you may also be able to help me tidy up my code as it takes ages to run when there is lot of data loaded in my tool. It may...

Hello, I have a Workbook which consists of a monthly worksheets of different types. The Worksheets are loaded from a user form and when they are created they are named e.g. "mscOctober". From the data which is in these sheets, pivot tables are created, as well as named ranges on...

Hi, I want to have a form which has a list box of item (lstSource) and an empty list box(lstDestination) which I can pass items to by pressing an add button and can also delete them via a delete button. I then want to run a query via an OK button which returns a number of rows from a table...

Thanks for the tip,just for your interest I realised what the problem was. Microsoft query date formats were not compatible with the format in the database meaning I could not use parameters to extract to my spreadsheet. I just changed DATE to CHAR and now it works. I suppose i should have...

Hi, I have a problem quering terradata using Microsoft query, to enter into a spreadsheet. The problem may be:- (a) My SQL is wrong? (b) Micorsoft query cannot handle such a complex query which uses parameters (I get the error "parameters are not allowed in queries that can't be...

Hi, I have a problem quering terradata using Microsoft query, to enter into a spreadsheet. The problem may be:- (a) My SQL is wrong? (b) Micorsoft query cannot handle such a complex query which uses parameters (I get the error "parameters are not allowed in queries that can't be...

Sorry I have looked at shell execute in these pages but have not found anything that fits my purpose, or more to the point nothing i can figure out how to change. Instead here is the script I am using to parse my file, it runs from the web browser. How do I do this in excel? <HTML> <HEAD>...

Hello, I posted this question I while ago and got no replies so I thought I would try again. Does anybody know how to write a command line or create a macro to run VB script from within excel. (A button which runs a script). The script uses regular expressions and as such I dont think you can...

Thanks for the reply. I don't have WSH installed, however, I have just contacted IT to sort it out. I want the script to extract data from a text file in a specified file location, read each line and choose what I want and then import into my spreadsheet so I can analyse it. I have heard it...

Hi, I was wondering whether it is possible to run a VB script from an excel(97) command button or macro and if so how. I know excel 2000 has a script editor. Perhaps the best way would be to have an excel macro open the html view and have a button to run my script from there, however, it...

Hello, Sorry still not working, I keep getting a Run-time error 2391 saying field &quot;F1&quot; not found. I have checked the spreadsheet that I am importing and it has no field name f1 and the tbl I am importing to has no field name f1, so I assume I must still have the code wrong. Sorry to...