Search:

Type: Posts; User: Nvablejrg; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Shade a cell when it is within a percent range

    Thank you for your response.

    I thought I would have to do the way you suggested but it is not working for me.

    I will continue to wrestle with it using trial and error. It is probably staring ...
  2. Shade a cell when it is within a percent range

    Goodday everyone,

    I am trying to figure out how to get a cell to shade when my metric is in between a percentage range. I need it to be green within the tolerance and red outside.

    I cannot...
  3. Re: Want to get a sub row with + sign as in Access.

    Oh well, i did not think so. I have never seen it. I appreciate your response, THANK YOU.
  4. Want to get a sub row with + sign as in Access.

    I was wondering if there was a way to get subrows as in Access when you have a main item and it has the (+) sign and you click and more rows drop down. Below is a small sample:


    <TBODY>
    Material...
  5. Re: Access Database Won't Open - NO Error Messages

    Never had to do the above to get mine to work.

    I am no guru by any means but I have had a similar problem and I figured if it works for Outlook it can work for Access.

    I went to...
  6. Re: Name cells in numerical order instead of one by one

    My hats off to you. I created another clean workbook and added info. I applied your macro and instantly named the cells I wanted. I did not have to go cell by cell. :bow:

    This thread is solved.
    ...
  7. Re: Name cells in numerical order instead of one by one

    <TABLE style="WIDTH: 518pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=690><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL...
  8. Re: Name cells in numerical order instead of one by one

    I am using Excel 2007

    Nvablejrg
  9. Re: Name cells in numerical order instead of one by one

    Thanks fo rthe quick reply

    WOW!

    You mentioned about generating names in an automated way. How do you do that?

    Macros, scare me. I get in there and I am lost. LOL

    I can sufficiently...
  10. Name cells in numerical order instead of one by one

    <TABLE style="WIDTH: 977pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1300><COLGROUP><COL style="WIDTH: 39pt; mso-width-source: userset; mso-width-alt: 1901" width=52><COL...
  11. Replies
    6
    Views
    6,578

    Re: Sort worksheets

    Looks like I am sold on Easy-XL this will help so much at work. Thank you all for your assistance. Another case closed on Mr Excel's Message boards.

    Two in one day!!!:laugh:
  12. Replies
    6
    Views
    6,578

    Re: Sort worksheets

    Norie - The PUP7 on JWalk has this feature. I have downloaded a trial version and tried it and works. I was able to sort the worksheet tabs in alphanumeric order. I like the feature but I am finding...
  13. Replies
    6
    Views
    6,578

    Re: Sort worksheets

    I need to rephrase the question. I am looking to sort the WORKSHEET TABS in alpha-numerical order.

    Thank you.
  14. Replies
    6
    Views
    6,578

    Sort worksheets

    Is there a way to sort worksheets in Easy-XL? This add-in looks great!!! If there is a way to sort worksheets I probably missed it but it will seal the deal for me.

    Thank you!:)
  15. Re: Corresponding cell to highlight inaccordance with another cells result

    You underdstood exactly what I wanted. Thank you so very much for your assistance, the formulas work great. I believe I can adapt to the rest of my Dashboard as required.

    Thank you again, case...
  16. Re: Corresponding cell to highlight inaccordance with another cells result

    Sure, thanks for the speedy response.

    The PRCNT TTL is 76% therefore it should only show up in the RED column. If PRCNT TTL was 86% it would only showup in the AMBER column, and so on for GREEN....
  17. Corresponding cell to highlight inaccordance with another cells result

    <TABLE style="WIDTH: 353pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=469 border=0><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL...
  18. Re: Change one cell and it affects 3 or 4 other cells

    Thank you so VERY much. All of your help is greatly appreciated. It works like charm. That is exactly what I needed.
  19. Re: Change one cell and it affects 3 or 4 other cells

    You are pretty much on the nose. I need to know how many males and females are still PDY after others have departed. I do not need to account for the Departures, but I still may need to refer back to...
  20. Re: Change one cell and it affects 3 or 4 other cells

    Thank you for a quick response,

    This is my first post to a forum

    The BOG is the number of personel in the area at the present time.

    Once some leaves the area the are "Departure"d so to...
  21. Change one cell and it affects 3 or 4 other cells

    Everyone, Thank you in Advance

    <TABLE style="WIDTH: 533pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=710 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><COL...
Results 1 to 21 of 21