Results 1 to 5 of 5

Compare Sheets and Display the previous sheets column in current sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    244

    Compare Sheets and Display the previous sheets column in current sheets

    I have attached 02 excel sheets, 1 sheet name is original another sheet name is working, now i want to workout in working sheet. In working sheet birth year col. is blank, in original sheets birth sheets is filled now I need to compare both sheets and bring in working sheet output birth year column need to fill from comparing of original sheets. I think lookup command is used for this. But i don't know how to do easily ? So may i request you to please provide me the clear solution.

    Kindly note both sheet common col. is borrower id.
    Attached Files Attached Files
    Last edited by maddyrafi1987; 05-09-2017 at 03:12 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-23-2015, 10:15 PM
  2. [SOLVED] VBA code for current sheets is max sheets of workbook
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-09-2014, 11:50 AM
  3. Replies: 4
    Last Post: 01-15-2014, 10:26 AM
  4. Compare and add from all previous sheets
    By khateeb in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-06-2013, 06:36 AM
  5. Replies: 2
    Last Post: 01-18-2012, 05:08 AM
  6. Copying New sheets using formulas involving previous sheets
    By mcsc03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2008, 06:01 PM
  7. Replies: 2
    Last Post: 07-04-2006, 10:33 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