Search results for query: *

I have data formatted in excel like the below: a b c xxx 10 20 60 yyy 30 10 20 ttt 40 5 15 vvv 50 70 30 And I would like to automatically get the data formatted in another worksheet like this via formula or some other auto means: xxx 10 a xxx 20 b xxx 60 c yyy 30 a yyy 10 b yyy...

is it possible to create a executable file to open various programs all at once? thanks

I was wondering if it is possible to create an executable that opens various programs for me? It would be nice to just run the .exe and have all of my ten programs open up automatically. let me know if this is possible thanks

I have one column: Date 1/1/2007 1/2/2007 1/3/2007 1/4/2007 1/5/2007 1/6/2007 1/7/2007 1/8/2007 This data range will expand each day. I want a dynamic formula that subtracts the "last" date from the first date automatically. Is this possible in a formula? I do not want to use named ranges.

SO I am getting this in a few cells (which I am expecting to), the problem arises when I try to Sum the column. It will not do this b/c of the non-numerical text in the columns. Does anybody know of a workaround? thanks jt

I have a simple crosstab query in Access. In column "Security" is a list of securities and their strike prices. The strike price always follows the text "k=" and i need to just grab the strike value and put it another field. Unfortunately the numbers of spaces before & after the strike vary...

Ok - I have a problem here. I am trying to create a dynamic defined range using the offset & count functions, but I am not sure how to grab the range I am looking for. I have column C populated with a whole bunch of numbers. Each month we add additional numbers to the column, and I want a...

is it possible to create a formulas like so: =sumif($A3:$A15000,($C$15004),CORREL($B$13609:$B14446,G$13609:G14446)) where i embed a correlation function within the sumif function? thanks

Currently a linked table has a "Date" field that is data type text. Field is populated as such: 20070418 I have written an expression to get it 04/18/2007, but when i try to link to other tables via queries I get the wonderful data type mismatch b/c the other tables are all using data type...

Currently this is how my data is set up: ColA: ColB: ColC: ColD: ColE: ColF: Broker Dec-05 Nov-05 Oct-05 Sep-05 Aug-05 ABN ASIA 29,908 14,999 5,697 BARCLAYS CAPITAL 88,509 152,304 90,262 24,011 2,928 but i would like to get it like this: Column A: Col B...

Currently I have the following code and was wondering how to condense it b/c i do not want to keep writing this for every single row I add to the sheet. The sheet will vary in length. Sub CQG_Update() Application.ScreenUpdating = False 'Row 3' Range("D3").Formula = "=CQGPC|" &...

Here is my problem: I have two columns as below CCH7 Cocoa, Mar 07 P.CCH71450 Cocoa, Mar 07 1450 Put P.CFF7105 Coffee, Jan 07 1050 Put C.CFH7135 Coffee, Mar 07 1350 Call CTH7 Cotton, Mar 07 CTH7 Cotton, Mar 07 P.CTH750 Cotton, Mar 07 50 Put C.SUH712 Sugar World #11...

when i use the following: Range("I9").Value = "=(G9+H9)/2" Range("I11").Value = "=(G11+H11)/2" Range("I20").Value = "=(G20+H20)/2" Range("I22").Value = "=(G22+H22)/2" Range("I25").Value = "=(G25+H25)/2" Range("I6").Value = "=((G6+H6)/2)-I$9" Range("I7").Value = "=((G7+H7)/2)-I$9"...

I am trying to sum information on sheet1 based on criteria and put it into sheet2. The data in sht1 updates every 10 seconds and everytime it updates I want it to overwrite the data in sht2. Also, I would like to sort the values descending. So far I have this: Private Sub...

Currently I am running the following codes on two seperate worksheets, but would like to run both on the same wrksheet. How do you combine the two subs into one? Private Sub Worksheet_Change(ByVal Target As Range) Dim lRow As Long, WF As WorksheetFunction Set WF =...

Hi All, Currently I have the following code which works great at subtotaling column"D:D" in my sheet: Private Sub Worksheet_Change(ByVal Target As Range) Dim lRow As Long, WF As WorksheetFunction Set WF = Application.WorksheetFunction If Not Application.Intersect(Target...

OK - so I am trying to use this code for my problem: Sub DeleteSomeRowsPlease() Dim ws As Worksheet, rngFilter As Range, rngDel As Range Set ws = Sheets("Sheet1") 'set as desired On Error Resume Next 'for SpecialCells Application.DisplayAlerts = False...

Is there a way to delete whole rows based on criteria contained within the row/column? For example: Col1 Col2 Col3 23 rt cd 56 gh cd 21 df jp I would want to delete rows 1 & 2 b/c col3 did not have "jp" in the field, but keep row 3 b/c data in column 3 did have...

I want to grab dynamic data from a worksheet1 and place it in worksheet2 with the value and a timestamp in the cell next to it. The data in worksheet1 gets refreshed every minute, so I would like the data that is being populated in wrksheet2 to create a list and not get over written...

I want to grab dynamic data from a worksheet1 and place it in worksheet2 with the value and a timestamp in the cell next to it. The data in worksheet1 gets refreshed every minute, so I would like the data that is being populated in wrksheet2 to create a list and not get over written...