Results 1 to 7 of 7

Autopopulate linked worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2013
    Posts
    19

    Autopopulate linked worksheets

    I have a workbook (Excel 2010) that I use constantly. I am always deleting/adding rows in the main "Entry Sheet" and need the calculations in column D of my "JE Sheet" to autopopulate with the numbers in column C & D of my "Entry Sheet" based on matching information in column B on both sheets.

    What formula do I need to place in column D of my JE Sheet in order to pull in the correct information from my Entry Sheet without having to manually adjust the formula each time?

    I cannot seem to get a VLookup or a SUMIF to work for me and keep working even with changes, but more than likely it is user error on my part.

    I have attached a sample to clarify what I need.

    Thanks for any help!

    D.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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