Consulting

Results 1 to 5 of 5

Thread: Display succeeding column data while skipping blank cells

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Jul 2021
    Posts
    2
    Location

    Display succeeding column data while skipping blank cells

    Hi All,

    I would like to get your expert advise on how to get around this issue I am encountering.

    I am trying to populate a cells so that it will lookup the value from row while skipping blank cells within that row and displaying those values in a column.

    So whenever a lookup value is populated on C3, it will lookup DataSheet sheet from Column B to O and display the value on cell C6 to C8 skipping blank cells.

    Thank you! Appreciate anyone's assistance on this.
    Attached Files Attached Files

Posting Permissions

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