Recent content by jackmanjls

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