+ Reply to Thread
Results 1 to 6 of 6

Copying Data Between Sheets

Hybrid View

  1. 09-04-2013, 06:53 PM #1
    irish_goat
    irish_goat is offline
    Registered User
    Join Date
    09-04-2013
    Location
    Derry
    MS-Off Ver
    Excel 2007
    Posts
    2

    Copying Data Between Sheets

    Hi folks, just a quick question.

    I have 2 sheets with data on property.

    Sheet 1 has column A and B
    Sheet 2 has column C

    A and C both contain unique property numbers which 99% match up (there are a few in column A that aren't in C and vice versa). Is there anyway for me to copy column B into Sheet 2 and get it to line up with column C so that the unique property numbers sync up.

    Hope I've phrased that ok for you'se all.

    Cheers.
    Reply With QuoteRegister To Reply
  2. 09-04-2013, 08:17 PM #2
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Copying Data Between Sheets

    In column B of sheet2 enter this formula and copy down:

    Formula: copy to clipboard 
    =INDEX(Sheet1!B1:B500,MATCH(Sheet2!C1,Sheet1!A1:A500,0))
    Change the cell references to match your data
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  3. 09-05-2013, 05:27 AM #3
    irish_goat
    irish_goat is offline
    Registered User
    Join Date
    09-04-2013
    Location
    Derry
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Copying Data Between Sheets

    Cheers for the response but it's not working for me. Been a few years since I've done much with Excel so I'm not sure where I've gone wrong. I've taken 2 screenshots if you've time to check it out.

    http://imageshack.us/a/img202/3782/7p3i.jpg

    http://imageshack.us/a/img46/9471/27om.jpg

    Thanks again.
    Reply With QuoteRegister To Reply
  4. 09-05-2013, 05:35 AM #4
    irish_goat
    irish_goat is offline
    Registered User
    Join Date
    09-04-2013
    Location
    Derry
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Copying Data Between Sheets

    Cheers for the response but it's not working for me. It's been a good few years since I've used Excel so I'm probably missing something.

    Have included 2 screenshots if you have time to take a look.

    http://imageshack.us/a/img46/9471/27om.jpg

    http://imageshack.us/a/img202/3782/7p3i.jpg

    Thanks again.
    Reply With QuoteRegister To Reply
  5. 09-05-2013, 05:57 AM #5
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Copying Data Between Sheets

    Could you post your workbook?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  6. 09-05-2013, 09:26 AM #6
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Copying Data Between Sheets

    Your description and pictures of your data don't match at all. The only thing that they have in common is column A not column C as you describe in the question so the formula in column B would be something like this:

    Formula: copy to clipboard 
    =INDEX(Sheet1!B1:B500,MATCH(Sheet2!A1,Sheet1!A1:A500,0))
    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. Create new sheets copying All the data of a specific sheet and gining names to all sheets
    By Fotis1991 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-01-2013, 12:20 PM
  2. [SOLVED] Copying data to different sheets
    By dean.grimshaw in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-13-2012, 09:29 AM
  3. Copying data from sheets into one
    By IvarZhukovsky in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 06:12 AM
  4. Copying Data between sheets
    By aquajock98 in forum Excel General
    Replies: 2
    Last Post: 04-30-2010, 06:02 PM
  5. copying data between sheets
    By davetherave in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-05-2007, 07:03 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1