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.

That's pretty cool...thanks.

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 never thought. I googled excel split col and found what I needed. Thanks for responding

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...

Now that I agree with. Problem solved. Thanks for your time, Jack

Narayan, I ran a little test ss to verify what you said. This is what I did. In E1:E3 I put data. E4 is empty. E5 has the number 6 E6 has E5/COUNT(E1:E3) Placing the cursor at E4 and adding a row did not increment the COUNT. The formula did not change automatically. If it's suppose to then...

At first I thought it would be easier on this forum to just take a simple SUM formula and then apply to my situation but it might be more informative to look at the real layout. So, here's what I actually have. N20:N22 has the data that I want to COUNT. N23 is blank. N24 to N25 have other...

Thanks for your response. I think I can make this clear and answer your q. Initially I have data in N20:N22 and in N26 (last used) I have sum(N20:N22). So the entire range of this portion of the ss is N20 to N26. It's important to note that there's data, that I don't want to include, before and...

This calc occurs in the middle of the ss. Assume there's data in N20:N22 and the sum results is in N26. Assume that I add 1 col N23 the results will now be in N27.

That does work but it creates another potential issue. Here's the problem. Let's assume that my current ss only uses N20-N50 rows for my calc, as I continue in this year I could add anywhere from 0 to 3 rows/day. So, what i want to do is limit the calc to only the current N20-N50 rows. I want to...

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...

This was the problem. Here's the solution for EXCEL 2007: Go to the Office Button, select Excel Options (lower right hand corner), Formulas, Calculation options (at the top pf the page) and set Workbook Options to Automatic. Thanks to those that responded.

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...

Hui...you are da man.

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...

In conclusion I'd like to document what I did. I copied row 2 with the CF properties and then did a hide. I then wrote a small macro that inserted a row below the hidden row using Alt+I+R. In the new row, 1st col I added today's date (Ctrl+;) and then copied the CF properties to the new row. I...

This is the link: http://speedy.sh/v6jaB/SampleChandoo.xlsx The quest is to add a new row that has all the CF properties as the other data rows.

How do i upload a sample file?

The 1st row of the ss is the column headings, they are in bold. The 2nd and successive lines have the data with CF properties. If i highlight the 1st line of data (not the heading row but the 1st data row) and add a line using Alt-I-R it doesn't copy the CF properties, in fact, the line has...