• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Open default SS

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

    Directory of headings in worksheet

    That's pretty cool...thanks.
  3. J

    Directory of headings in worksheet

    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?
  4. J

    Sorting Col w/ date and alpha char's

    I never thought. I googled excel split col and found what I needed. Thanks for responding
  5. J

    Sorting Col w/ date and alpha char's

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

    Append worksheets

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

    Variable length records

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

    End of col

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

    End of col

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

    End of col

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

    End of col

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

    End of col

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

    End of col

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

    End of col

    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?
  15. J

    Wrap text

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

    Macro issue

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

    Macro issue

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

    Remove password

    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?
  19. J

    Chart axis

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

    Macro change

    Hui...you are da man.
  21. J

    Macro change

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

    Multiple Conditional formatting

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

    Multiple Conditional formatting

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

    Multiple Conditional formatting

    How do i upload a sample file?
  25. J

    Multiple Conditional formatting

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