Results 1 to 2 of 2

Find value in multiple columns and paste value in adjacent cell

Threaded View

  1. 07-31-2021, 10:37 AM #1
    dzas1632
    dzas1632 is offline
    Registered User
    Join Date
    07-31-2021
    Location
    Chicago
    MS-Off Ver
    Office 365
    Posts
    1

    Find value in multiple columns and paste value in adjacent cell

    I have a work book where on one page, "Display", I want to search columns I,K,M and O for a numeric ZERO 0 value and when found paste "NA" in the cell immediately to the right. I can not seem to get the VB code for a macro nailed down. Any help would be appreciated.

    I want it to search from row 5 to bottom of work book in each row.

    Thank you in advance.
    Last edited by dzas1632; 07-31-2021 at 03:07 PM. Reason: I have Office 365
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Find Cell, Copy contents in adjacent cells, then paste to new item
    By wakaan808 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2019, 02:01 PM
  2. find relative merge cell data and paste adjacent range
    By cgat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2018, 10:44 PM
  3. Find matches, copy and paste adjacent cell
    By amein in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-23-2016, 11:21 AM
  4. [SOLVED] Macro to find specific word in cell and then copy and paste the adjacent cell upwards
    By raytej82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2014, 05:33 PM
  5. Find text in a range on basis of dropdown selection & paste value adjacent cell
    By excel student in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2013, 08:06 AM
  6. Need to find a word in a cell, copy the entire cell and two adjacent columns on same row
    By hang_sandwich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 11:16 AM
  7. [SOLVED] find value, copy value of adjacent cell and paste it on another sheet
    By Ajgor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2012, 04:21 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1