+ Reply to Thread
Results 1 to 4 of 4

Assistance needed in amending a macro.

  1. #1
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    140

    Assistance needed in amending a macro.

    Hi

    Was given the macro shown below and what it does is compares data between sheets 1 & 2 and marks up on sheet 1 as duplicate/missing or OK.

    What im trying to do is to run the missing /OK part of the macro but when its duplicated in sheet 2 I need it to show duplicate but if data is duplicated and also shown on sheet 1 i need it to say "duplicated and on sheet 1" and if duplicated and not on sheet 1 just show "duplicated"

    Macro shown below.

    Please Login or Register  to view this content.
    Any Ideas?

    Thanks

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Assistance needed in amending a macro.

    Unless I have misread your macro. it is comparing a value on sheet 1 to values on sheet 2. So if it shows Duplicate, in the display cell in column E of sheet 1, it should be evident that the item is also on sheet 1. Or maybe I have misread your objective.
    Last edited by JLGWhiz; 07-14-2019 at 05:29 PM.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Assistance needed in amending a macro.

    In case you are wanting to check for more than one entry of items on sheet 1, this modified code might be what you want.

    Please Login or Register  to view this content.
    But it will add processing time to your macro.

  4. #4
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    140

    Re: Assistance needed in amending a macro.

    Sorry if I confused you but it spot on. Thanks

+ 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] Amending a macro that has been recorded
    By Eduards in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2019, 07:14 AM
  2. Replies: 1
    Last Post: 09-11-2013, 10:53 AM
  3. Macro assistance needed for complex export/import excel file
    By dedavie in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-28-2013, 02:47 PM
  4. Help amending a macro needed
    By AdamBee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2013, 08:53 AM
  5. [SOLVED] Conditional Formatting for duplicates--Macro assistance needed
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-28-2012, 10:10 AM
  6. Macro Assistance Needed for Scheduling
    By jhashmore in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-13-2012, 11:30 AM
  7. Amending basic Macro function
    By makana in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2009, 08:24 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1