Consulting

Results 1 to 2 of 2

Thread: compare values and paste in another woksheet

  1. #1

    compare values and paste in another woksheet

    Hi all,
    I have a worksheet that has a column "F" that has a drop down list between cells F24 to F63 with the following options
    "crack"
    "No Crack"
    and a blank value

    What i would like to do is sort each of these values and past into a cell in another work sheet

    if all cells in the column = No Crack then paste "no Crack" in cell A1 of worksheet 2
    if all cells in the column = Crack then paste "Crack" in cell A1 of worksheet 2
    if a single cell in the column = Crack then paste "Crack" in cell A1 of worksheet 2

    And if the pasted value ="Crack" then i want the cell to have red fill with white text.
    Is this possible to do in VBA and if so how.

  2. #2
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    Did my reply at the cross post not help?
    http://www.ozgrid.com/forum/showthread.php?t=158201

    Please read this link about cross-posting and post a link to any future cross-posts

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •