Consulting

Results 1 to 5 of 5

Thread: HELP Getting data to final sheet based on highlighted cells!!!

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jun 2019
    Posts
    50
    Location

    HELP Getting data to final sheet based on highlighted cells!!!

    Hello,
    In Sheet1, I have rows 3,4, and 5 that contain cells that are highlighted. The highlighted cells after column A and B show that the data is bad and should not be put in final sheet. Each highlighted cell is in a column and other named ranges corresponding to that same column will not go in the final sheet.

    I want to make a code that will pick only the columns in the named range set that corresponds to none of the highlighted cells ( I can have all of the named ranges pulled over even the ones in Sheet2 EXCEPT the named range called "POP") to bring to the final sheet called "Final_504", taking their data in column A and B along with them.

    I made the outcome manually in the final sheet to let you see what I am saying but I need to code it in a generic way. So if I was to do this with 500 data points, I could.

    Can anyone help me with this?
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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