Search results for query: *

Hi, I have the following code,created using the Excel macro recorder. Is it possible to change the parts that refer to "HELP" so that it refers to cell H25, so that when I change the text within cell H25 and run the macro again it will create a new Hyperlink,called whatever text is displayed...

Hi, I have a macro called "TRIAL" shown at the bottom of this post, the macro executes the section of code shown below THREE times when running(SHOWN IN RED) Dim strSheet As String strSheet = Sheets("CONTROL PANEL"). Range("A1").Value Sheets(strSheet).Select 'Sheets("BRENT CRUDE").Select...

Hi, Does anybody know how to stop the Solver Results Dialog Box appearing ? I want to accept the solver results and carry on with the rest of my macro. Really appreciate the help Ade Sub METASTOCKSOLVER() Sheets("CALC").Select SolverOk SetCell:="$F$21", MaxMinVal:=1...

Hi, I have a Data Validation list in cell A1 of a worksheet called LIST. I would like to modify the macro that I have recorded, the macro uses data from various worksheets. I would like to sort out some code so that at certain points in the macro it will select the worksheet that is shown in...

Hi, I have a workbook that contains a worksheet called CALC , in column A of this worksheet I have a list of other worksheets that I would like to run a macro on. Would it be possible to set up some code that would select the worksheet at the top of the list, perform a macro then select the...

Hi , I am aware of the Application On Time method of running a macro at a set time of day. Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro. Example times: ("21:30:10") ("22:00:10")...

Hi , I am aware of the Application On Time method of running a macro at a set time of day. Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro. Example times: ("21:30:10") ("22:00:10")...

Hi , I am aware of the Application On Time method of running a macro at a set time of day. Excel receives realtime data around the clock from another program via DDE links,about 10 seconds after every half hour I would like to run my macro. Example times: ("21:30:10") ("22:00:10")...

Hi, I have imported realtime currency prices into a spreadsheet using DDE links, if I have 5 rows showing the last 5 days prices the data is displayed with the most recent days record at the bottom of the table however I would like the most recent records to be displayed at the top. ACTUAL...

Hi, I am new to Pivot Tables so I would really appreciate any ideas. Below I have some data showing closing levels of The Ftse 100 share index, only trading days are shown in then left hand column. I want to sort my data by time periods such as weeks,months,years etc, which I have managed...

Hi, Below I have a table showing various prices reached during the trading day of the Ftse 100 share index.A new row will be added to the DAILY table at 10pm after the end of each days trading and not before. I would like to convert the daily data into a weekly time frame, showing the same...

Hi, I have data for the Dow Jones Stock Index, a sample of which is below and my data goes back over 20 years in total. In column A, I have the high price achieved each month. What I would like to do would be to calculate the high price achieved for each completed year. So the last completed...

Hi I am importing Financial Market data into Excel,this seems to work ok,i would like the updates to take place at a specific time of day. I have looked at the External Data Range Properties box(refresh control)this allows three options,none of which are what i really need. I would like to...

Hi all I have amounts in column C that need to be multiplied by a certain percentage to give profit figures which need to be shown in column D. The percentage to be used in the calculation depends upon the range that the value in column C appears. ---Col F----------------Col G >0<=500,000...

Hi I have the IF formula below that works ok,based on the values shown in column AB(122:126),the result would be "BUY". The formula works if i just type in the text in column AB(122:126),however if i use the paste link to insert the values in column AB the formula stops working. I know i...

Hi I am using the date formula below to give me the name of the months found in column M This works ok apart from the times that there is no date to be found in certain cells in column M and they are blank cells,the formula then returns the result JANUARY. When cells in column M are blank i...

Hi I am using the formula below to look for times in column BE and then use the lookup table to assign a number from 1-6 that equates to four hour blocks of time. The formula works ok, apart from when 00:00:00 times are involved and then i get a #N/A error message,based on the lookup table...

Hi I am using the two SUMPRODUCT formulas below to find how many times positive or negative values(shown in column BJ)appear at certain times of day.Times are located in column BE. I have repeated the formula to perform the same test for every hour of the day. These formulas worked when i...

Hi Not quite sure of the best way to approach this problem I need to filter the data in the table below into quarters Jan-Mar Apr-Jun Jul-Sept Oct-Dec For each quarter i need to find the change in values,i need to subtract the open price in each quarter(Jan,Apr,Jul,Oct) from the closing price...

Hi I am using the Countif function below to find the number of times that a particular month name appears in the column AH. =COUNTIF(AH2:AH299,"APRIL") I have another column AJ that contains positive and negative values that relate to each month shown in column AH. I would like to write a...