Results 1 to 10 of 10

Thread: Transfer columns from comparable workbook if cell value exists

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-02-2023, 12:26 AM #6
    jdelano
    jdelano is offline
    VBAX Contributor
    Joined
    Sep 2023
    Posts
    153
    Location
    I'll take a look at the files.

    I changed this line 
    newWBCurrentDesc = newWBSheet.Cells(newWBDataRow, 4)
    to 
    newWBCurrentDesc = newWBSheet.Cells(newWBDataRow, 6)
    so that the same columns were being compared. It worked okay for me.

    Let me know if that fixes it for you.
    Attached Images Attached Images
    Last edited by jdelano; 10-02-2023 at 12:42 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules