Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. copeco

    comparing numbers

    Good morning. I have a column(B) of numbers (with extra info next to each number)106048 r89989 bhk227t. In column(A), I will key numbers that may match column (B)numbers. If column (A)match any in colulmn (B) then I want to change background colors in column (A) and column (B)(with the extra...
  2. copeco

    If cell is blank

    Gents, My error. For some reason it didn't work b/4. The =IF(I6>"","","ea") formula works fine. I quess I syntax erored it or something....thanks much guys!!!!!!!!!1
  3. copeco

    If cell is blank

    Gents, Thanks for the info. I have tried all of them, but alass, none of them seem to work. The only one that works is if a zero "0" is in the H4 cell. If it is blank it won't work. Unless Vestax's... =If(H4="";"";if(H4>,"ea","")..may work but...
  4. copeco

    If cell is blank

    Using Excel in the cell I4 , =If $H4>" ","ea"," ") ??? what I'm trying to accomplish is: if H4 is greater than a blank then put "ea" in I4 else I4 is blank. The above formula works only if H4 has alpha charactors. I need it to work for numbers. ???...thanks
  5. copeco

    TRACKING TAB

    Microsoft Outlook (windows 2002XP)...Sent messages area In windows '98 there was a "tracking" tab that showed the time & date read...of the person you sent the message to and the time & date that person forwarded the message on to the next person. In windows 2002XP that tab does not...
  6. copeco

    add name & qty in header section

    Good morning. On a worksheet I have created a header (top row) with command buttons used to sort various data. The data is purchasing info. I want to add another button ?? that shows a person's name & # times that person's name appears in the list(how many times he/she has ordered things). I...
  7. copeco

    Stars if over 10

    tanks berry much..
  8. copeco

    Stars if over 10

    this works great. thanks much..where did you find the REPT ? I assme that is a repeat.
  9. copeco

    Star if>10

    thanks..much
  10. copeco

    Star if>10

    I have a list of names. The cell next to the name adds the number of times the name shows up in the worksheet. I'm wishing, in another area of the worksheet, to show a "*" (star) for every time over 10. e.g. 11=* 12=** I'm using EXCEL...thanks
  11. copeco

    Stars if over 10

    ...afternoon. I am creating a list of names. Next to each name is a cell showing how many that name is used. In another place on the same workpage I wish to show a "*" (star)for every time that name is used over 10 times. e.g. 11 times= * 12 times= ** etc. I am using this in EXCEL...
  12. copeco

    cursor to next blank line

    thanks for the info..I used the 1st one.Merry Christmas!!
  13. copeco

    cursor to next blank line

    Good morning. I use an excel sheet(many pages)for input of purchasing info. I am forever paging up & down looking for things. Right now the object is to have the cursor goto the bottom of the list & sit on the next unused line. I use Autofilter to find the next "blank" in the date...
  14. copeco

    macro "stop recording" window

    trampkp, I found it...It was in the customize,toolbars section. the "stop recording" box was not checked... Thanks so much for the help you have given me. Now I have toobars for record, play & relative reference at hand.
  15. copeco

    macro "stop recording" window

    The relative reference tool is usually on the right side of the "stop recording" toolbar. It changes the mode from absolute(a particular cell)to relative(the currently active cell,eg;anywhere you are on the page). My stop toolbar that usually appears when recording is missing.
  16. copeco

    macro "stop recording" window

    Trampkp, Thanks for the info. I also need the relative reference tool that is usually with the "stop recording" toolbar. Please.
  17. copeco

    macro "stop recording" window

    Good morning. I am creating a macro. Normally, when the macro starts there is a small "stop recording" window that shows up on the screen. This window does not show at this time. How do I activate it?
  18. copeco

    Items left open

    Geoff, I have practiced with the AutoFilter(couldn't figure out the AdvancedFilter). This one will work. The entire file has to be sent, but that's ok. Thanks for your help.
  19. copeco

    Items left open

    Geoff, Thanks for the info. In my situation, I have to forward a listing to another manager showing all the open PO's along with the rest of the corresponding info in the same row. I was trying to create a list on sheet2 that would be automatically updated. I'm not sure how to do that with...
  20. copeco

    Items left open

    Good morning.. File has rows A?:K? (open ended as rows are added frequently). row B?(date submitted) row F?(date rec'd) All this on sheet1. The "want to do" is: On sheet2 show all rows(A?:K?)that do have row B?(date submitted)filled in, but do not have row F? (date rec'd)filled...

Part and Inventory Search

Back
Top