+ Reply to Thread
Results 1 to 2 of 2

Autofill on one sheet based on an entry from another.

  1. #1
    Registered User
    Join Date
    01-31-2017
    Location
    Naples, Florida, USA
    MS-Off Ver
    2016
    Posts
    1

    Autofill on one sheet based on an entry from another.

    Hello everyone,

    So here is the question I have,
    There is a sheet where I enter contact information of my clients, such as name, email, number, purchase price, ect. And I have created a drop down box based on a define name, that says Yes or No. This yes or no meaning is the client in escrow currently or not.
    Another sheet tracks my escrow, and does the calculations based on the purchase price. Now I like to have the name of my clinets and their address as well as purchase price on both sheets.
    I was wondering, would it be possible to autofill that information on my Escrow Tracker sheet, from my clients Information sheet, based on if I select YES or NO in the escrow drop down box. If Yes, it autofills the Name column in to the other Name, Price in to Price ect.

    Thank you all!

  2. #2
    Registered User
    Join Date
    01-20-2017
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Autofill on one sheet based on an entry from another.

    Maybe you can add one column for an ID. The use index match to pull the data.

+ 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. [SOLVED] increase count on tracking sheet based on date entry between dates in another sheet
    By yogup in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2016, 05:14 AM
  2. [SOLVED] Cascade/Autofill Columns based on last row entry
    By ssss2005 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2015, 07:30 AM
  3. [SOLVED] Autofill that adjusts based on date entry
    By kevinjay1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2014, 02:17 AM
  4. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 PM
  5. Populate Sheet Based on Entry on Another Sheet
    By chocolate_ty2000 in forum Excel General
    Replies: 0
    Last Post: 03-15-2011, 02:29 PM
  6. [SOLVED] how do I make a new spread sheet pop up, based on an entry in a c.
    By jpryce in forum Excel General
    Replies: 1
    Last Post: 04-15-2005, 03:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1