+ Reply to Thread
Results 1 to 2 of 2

Filter as per criteria and enter value in visible cells

  1. #1
    Registered User
    Join Date
    11-03-2021
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Filter as per criteria and enter value in visible cells

    Hi Forum,

    I need help on the below task which i could break down into steps to follow and i would request contributors to help me out with this task.


    Instructions:
    Step1 : Need to filter "OK" in all Columns H to M and fill those visible rows in column T as "IN", column U as "NO"
    Step2: Filter out all and For next step filter only blank cells in column U
    Step3 : Then filter column F with "M" then come to column H and filter out "OK" and fill those visible rows in column T as "IN", column U as "Yes"
    Step4: Filter out all and for next step filer only blank cells in column U
    Step5: Then filter column F with "F" then come to columns I to M and filter without "OK" as criteria (means select all, other then "OK")
    Step5: fill those visible cells in column T as "OUT" and Column U as "SETOUT"
    Step6: remaining unfilled blank cells left in column T and U are expected to fill with column T as "IN", column U as "Yes"
    Step7: Unfilter all


    Thank you.
    Attached Files Attached Files
    Last edited by ashishadhib; 01-12-2022 at 05:18 AM.

  2. #2
    Registered User
    Join Date
    11-03-2021
    Location
    India
    MS-Off Ver
    2010
    Posts
    6

    Re: Filter as per criteria and enter value in visible cells

    Remaining columns are empty in the sample data but there will be data in all the columns.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combo box to select filter criteria, Filtering, Deleting visible cells
    By coryjacques in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2018, 03:28 PM
  2. VBA code to filter then clear visible cells
    By LilSisKin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2017, 08:32 PM
  3. [SOLVED] Filter data and copy visible cells based on criteria
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-11-2015, 06:04 AM
  4. Vlookup on Visible cells after filter particular value
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2014, 10:29 AM
  5. [SOLVED] Copy Filter Data and paste it on another workbook with special cells(Only Visible Cells)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-13-2014, 07:59 AM
  6. Copy to Visible cells after filter
    By vandanavai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2009, 01:29 PM
  7. Sum according to Auto filter non visible cells
    By ElmerS in forum Excel General
    Replies: 9
    Last Post: 08-10-2009, 12:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1