Results 1 to 5 of 5

Compare cell contents in different columns, then fill neighbouring cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2008
    Location
    Australia
    Posts
    5

    Compare cell contents in different columns, then fill neighbouring cells

    Hello,

    I'm sure this is an easy problem to solve - I just can't work out ANY (let alone a simple) solution.

    I have two sheets:
    - sheet 1 ('current')
    - sheet 2 ('31May')

    The data in column C is the same, although sorted differently and can't be re-sorted to be the same. Where the data in column C is the same in both sheets, I want to fill columns A and B into sheet 1. Please see the example attached (which is probably more clear than that description ).

    Any help would be greatly appreciated!!
    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. Fill in cells with a value based on a neighbouring column
    By ppataki in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-26-2014, 11:18 AM
  2. Macro to compare 2 columns cell contents and add 'Yes' flag for record
    By swarren6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 03:50 PM
  3. [SOLVED] VBA Code - Compare Adjacent Cells In two columns and clear contents when a match is found
    By Langer101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-03-2013, 06:22 AM
  4. [SOLVED] Combine Cell Contents to with a [return] or [fill with spaces] between each cells contents
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2012, 11:24 PM
  5. Counting cells conditional on neighbouring columns
    By BFee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-03-2010, 02:13 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