+ Reply to Thread
Results 1 to 2 of 2

VBA to find duplicate cell from another sheet based row

  1. #1
    Registered User
    Join Date
    05-01-2018
    Location
    Maine
    MS-Off Ver
    2010
    Posts
    87

    VBA to find duplicate cell from another sheet based row

    I have ran into an issue with a spreadsheet and is needing a refresh due to new data sources. I have tried to put together some code but I am lost because the object needs to be able to select the row that it is sitting on. I have included a test file if it helps.

    I am trying to come up with something that will
    1 when button is clicked it will move to column Z on the row that it is sitting on
    2 there will be a value there to remember
    3 match that value to column A on sheet2, there will be a duplicate most likely
    4 simply select (move excel view) the cell to the right of the duplicate- by one column

    Seems easy writing it out but I am having a hard time getting 1 from the steps above to work so I haven't really been able to even begin trying to figure it out.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,875

    Re: VBA to find duplicate cell from another sheet based row

    Check it out.

    Please Login or Register  to view this content.

+ 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. [SOLVED] VBA code to duplicate work sheet based on cell value and rename based on cell value
    By NASANASA in forum Excel Programming / VBA / Macros
    Replies: 51
    Last Post: 03-12-2020, 07:54 AM
  2. [SOLVED] VBA to highlight row based on duplicate cell from another sheet
    By Axis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2016, 08:33 AM
  3. [SOLVED] Find sum in other sheet based on name and last used cell in column
    By abjac in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-16-2013, 04:55 PM
  4. [SOLVED] Delete rows based on duplicate cell, but leaving first and last duplicate.
    By LadyNicole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 05:07 AM
  5. Macro to find sheet name based on info in a cell
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2012, 11:07 PM
  6. Find a sheet based on cell and then sumif or sumproduct
    By jimstrongy in forum Excel General
    Replies: 7
    Last Post: 02-10-2012, 12:43 AM
  7. Replies: 1
    Last Post: 01-26-2012, 10:06 AM

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