+ Reply to Thread
Results 1 to 2 of 2

Combining data from two sheets

  1. 05-22-2014, 10:02 AM #1
    Ankka
    Ankka is offline
    Registered User
    Join Date
    05-22-2014
    Posts
    4

    Combining data from two sheets

    OK, I'll try to explain this so that you can understand..

    I have two sheets, let's say 1 and 2. Sheet 1 has a lot of data and sheet 1 has just three columns. The thing is that sheet 2 has valid data only and sheet 1 has some invalid data but the valid data in sheet 1 is the same as the data in sheet 2. Now I want to get the valid data from sheet 2 to sheet 1 so that the matching data will show in green colour.

    Does this make any sense?

    Edit: The C column in sheet 1 is the same as the I column in sheet 2. The difference is that sheet 1 has all the valid data and I want these to show on sheet 2 in green colour

    Edit2: I'm using Excel 2010
    Last edited by Ankka; 05-22-2014 at 10:08 AM. Reason: making more clear
    Reply With QuoteRegister To Reply
  2. 05-23-2014, 02:10 PM #2
    aydeegee
    aydeegee is offline
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Combining data from two sheets

    Hi Ankka

    I think that the attached file does what you want. The green is achieved by using conditional formatting.

    Let me know if anything need changing.

    Regards
    Alastair
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with combining Data from 2 sheets
    By Conradforbis in forum Excel General
    Replies: 3
    Last Post: 03-23-2012, 02:43 PM
  2. Need Combining data from two sheets
    By GirlFromOz in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 03-10-2007, 05:31 PM
  3. Combining data from two sheets
    By sparren in forum Excel General
    Replies: 7
    Last Post: 02-10-2007, 03:59 PM
  4. help with combining data from 2 sheets
    By unclegar95 in forum Excel General
    Replies: 2
    Last Post: 10-11-2006, 06:16 AM
  5. Combining data from different sheets in one
    By viktor in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-07-2005, 05:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1