Results 1 to 6 of 6

Help defining range for macro comparing values in 2 columns and worksheets

Threaded View

4lysaabri Help defining range for macro... 08-29-2014, 01:02 AM
venkat1926 Re: Help defining range for... 08-29-2014, 04:14 AM
venkat1926 Re: Help defining range for... 08-29-2014, 04:16 AM
4lysaabri Re: Help defining range for... 08-29-2014, 08:11 AM
watersev Re: Help defining range for... 08-29-2014, 08:38 AM
4lysaabri Re: Help defining range for... 08-29-2014, 02:50 PM
  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    8

    Help defining range for macro comparing values in 2 columns and worksheets

    Hi, hoping someone can help me. I have an excel workbook with 2 worksheets, 'Source' and 'Master'. When a command button is clicked on the Master worksheet, a macro is run to compare the values in 2 specific columns on the 2 worksheets and paste any values that is not in column 'A' on the Source worksheet in the next available row in column 'D' on the Master worksheet along with the associated data in that row from columns 'B', 'C' and 'D' on the source worksheet. (rows A, B and C on the master remain blank). Right now, only 2 of the values from the source worksheet is being copied to column D on the master worksheet. The values missing from the master worksheet are in red on the source sheet...so this is what I would expect would be copied to the master worksheet. If someone can let me know why the entire range of column A on the source sheet is not being taken into consideration for the compare, I'd appreciate it. I've attached a sample of the workbook which has the code I'm using for review. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro for conditional formatting based on the comparing values from adjacent columns
    By jkmasurkar in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-18-2012, 07:18 AM
  2. [SOLVED] Help: Defining a variable with an array of worksheets that use the same range
    By paulw793 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 03:34 PM
  3. Replies: 4
    Last Post: 08-08-2012, 01:21 AM
  4. Defining a Range over Multiple Worksheets
    By Tacitus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2011, 09:14 PM
  5. [SOLVED] Defining Range of For Each Loop for Cells and Worksheets
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2005, 09:06 AM

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