Search results

I have an excel document that I use often containing one sheets. How can I make that sheet the default, so each time I open the document it opens directly to the specified sheet? I thought if I did a file>save it would default to the last sheet displayed but I get a blank sheet for the default.

Is it possible to have a dir of headings in a worksheet? For instance, I have a single worksht. The worksht is ~2K lines. These lines are broken down into about 40 diff sections. Is it possible to have something like a dir where I can quickly go to a specific section from anywhere in the worksht?

I have a col that I want to sort. The fomat of the col is: mm/dd/yy-xx where, mm/dd/yy is the date, then the hyphen and finally the xx are 2 alpha chars. How can I sort so that the date is in ascending order? The -xx is not important. Some entries are: 10/22/13-AE 12/13/11-CP 12/18/11-CP...

I have 3 (actually I have 100) diff worksheets. Each worksheet has identical 12 col's and varying number of rows, from 100 to 230. I want to append all worksheets. The end master worksheet will have ws1 then ws2 then ws3. How can I do this?

I have records from a checking acct, for several yrs, that I want to put in excel. The records are in a text file. The records all have different length, for example: 35 22 MAR CVSPHARMACY #3274 Q03ST JAMES CITYFL $13.28 40 23 FEB PUBLIX #1007CAPE CORALFL $6.78 The constant between all...

I have the following code: =K36/COUNT(N20:N26) This is used in a calc. As I add more rows I want the N26 to increment accordingly. Assume that I add 2 rows the N26 will go to N28. Currently I go in the ss and update to N28. How can I get this to auto update as I add new rows?

I have a ss that has a series of a 2 row sequence. The top row has several column parameters while the row underneath has one long merged row where I type text. My question is about the second row. The second row is formatted to wrap text. When I enter text beyond the second row I would expect...

For this discussion assume that the following: A1=7/19/12, A2=135, A3=88, etc, B1=7/18/12, etc. 7/19/12 135 88 1.44 0.73 7/18/12 161 76 1.15 0.74 The objective is to enter data for the current day so I wrote a macro. When I put the cursor on 7/18/12 and run my macro it will add a row...

I downloaded a ss from the internet and it's password protected. I tried copy the worksheet to another but it's still pw protected. How can i remove the protection?

Assume that I have data with column headings of date-col1-col2, col3. I want to select a subset of this data and plot to a chart. I know how to create line charts. I want to have the x-axis as the col date and the chart data to be col3 data. I can't figure out how to select the date col and...

I have the following macro. At the row that I've marked "**" I want to put today's date in that cell by using a "Ctrl ;" or some other suggestion. What I'm getting is the date of the day the macro was created. So...I need to know the correct syntax so that I can modify the macro. Sub...

I've made some posts over the last few days and want to know how I can respond directly to the person(s) that responded. For instance, Hui responded to a post that I made yesterday. I added some additional q's, based on his response, to his post but not sure whether Hui actually receives the...

Is it possible to have a single rule that controls more than one cell color when doing a conditional formatting rule. For example, assume that we have a single cell that we want to color either red or green. Can we say something like if cell > 0 color green, if cell < 0 color red. I...

I'm not sure this is the place to ask this question. Is there anyway to search for a previous post based on the username. For example, assume I made a post about 6months back and want to retreive how do I do that?

I want to color more than 1 cell based on the values of 2 cells. I know how to write the cond. format rule to color a single cell. For example, assume that there are 2 cols names plus and down. The following logic would be used to color the cells. if plus<300 and down<300 and...

The following formula is used to calculate for stochastic oscillator. Do you know if this is available where I can download? Formula: %K = 100 ( C - L14) / ( H14 - L14) %D = SMA3 ( %K ) %K = Fast Stochastic, %D = Slow Stochastic C = Latest close L14 = Lowest close of the 14 previous...

I have a workbook with about 50 worksheets. How can I manage this so that I'm not looking through all worksheets to find the one I want? If I could something like Windows Explorer where there's directory and underlying files would be the best approach. Thanks

I have a scatter plot where the x-axis goes from 0 to 80 but my data's range is from 55 to 75. How can I adjust the scale on the x-axis?

I'm trying to get a simple plot using pilot charts. The example data I have is: y-axis -> -3,-2,-1,0,1,2,3 x-axis -> -5,-5,-3,0,1,2,2 I think what I need is a simple tutorial on how to create a simple pilot chart. I've googled but can't seem to get the plot I want. Do you have any...

I have a data file of stdDev's of volatility. The .csv file can contain anywhere from 100-200 records (1 record=1 line of date,data) of date and the stdDev data. The format for each record is mm/dd/yyyy, %1.2f. The range for the stdDev is +/-5.00. I have a Python program that outputs the .csv...

I want to calc the HV for several diff stock symbols. I would like to download ticker symbol data via Yahoo (it's free) and then calc the HV. I either want to automate this or keep the user intervention to a min. Any ideas? Thanks.

I want to create a ss that performs a calculation depending on the value in a specific row-col. For example, the range for A1 would be the following values, LS,SS, LC, SC, LP, SP. For each value of A1 there would be some calculation. In programming language it would take the following form...

For stock option trading there is a chart called a "Profit-and-Loss" form. I would like to create a template in xl and use during my analysis. The form consists of vertical scale and horizontal scale. The vert scale (y-axis) is left justified and starting from the bottom and working to the top...

I want to have a nested 'for' loop that prints the results to sequential horizontal cells. It would look something like the following: for x = 150 to 200 increment by 50 for y = 2% to 6% increment by 1% z = (some calculation involving x and y) print y and z to cells (see NOTE: below)...

Assume that I have an xl ss with all rows and cols in a nice orderly fashion. What I want to do is resize some of the cols without disturbing the col width for all other cells in that col? For example, assume I have col A that has 5 cells (A1:A5). I want to resize the col width of A3 to be...