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: *

  • Users: copeco
  • Content: Threads
  • Order by date
  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

    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
  3. 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...
  4. 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...
  5. 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
  6. copeco

    Stars if over 10

    good 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...
  7. 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...
  8. 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?
  9. 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...
  10. copeco

    EXCEL multi-cell to multi-cell comparison

    Criteria: Column A = names Column B-E = name/numbers (for a specific name) Column I-N = numbers (general totals) Required: If "all" the name/numbers(not added together but separatly)eg(8.0, 9.75,7.0)is found in the numbers(general)eg(8.0, 9.75, 7.0) then highlight...
  11. copeco

    excel inventory control

    Good morning. I have a list of part#s with quantities next to them. I want to be able to go to say sheet2(the list is on sheet1) and be able to key in a part# and add or subtract a quantity from that part# and the results show on sheet1. eg(part# _________ qty____(+ or -)) thanks..
  12. copeco

    Excel-number comparison

    Good morning. eg. There is a number input in cells A1,B1 & C1. There is a range of cells E1:H20. I'm wanting to compare the input cells to the range cells. If there is a match print the matching #s in D1:D?. pls help...thanks
  13. copeco

    conditional formatting

    I have created an order file in excel. Column A(desc),B(size),C(qty). C is normally blank. When something eg(1, 1 bx, 1 cs)is entered in C? the A?,B?,C? row should turn a different color. Using conditional formatting in column: C? : cell value is not between ="" and...

Part and Inventory Search

Back
Top