+ Reply to Thread
Results 1 to 5 of 5

Compare Sheets and Display the previous sheets column in current sheets

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

    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.

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Compare Sheets and Display the previous sheets column in current sheets

    Type in F2 and copy down.
    =IFERROR(VLOOKUP(B2,Original!$B$1:$F$51,5,0),"")
    Teach me Excel VBA

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

    Re: Compare Sheets and Display the previous sheets column in current sheets

    yes your are right but i need is if i delete original sheet birth year means col. means it need to be set automatically some year from 20 age to 58 age in that working cell suppose it was next next col. means the year should not be same. it must be random.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Compare Sheets and Display the previous sheets column in current sheets

    Please upload workbook with desired result manually put.I replied you exactly according to your first post.It seems you missed something there to mention.

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

    Re: Compare Sheets and Display the previous sheets column in current sheets

    next column is repayment loan amount with interest thats it.

+ Reply to Thread

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