+ Reply to Thread
Results 1 to 2 of 2

Formula to link cells in different tabs so that they autofill?

  1. #1
    Registered User
    Join Date
    02-26-2016
    Location
    Edmonton, AB
    MS-Off Ver
    2013
    Posts
    4

    Formula to link cells in different tabs so that they autofill?

    I'm looking for a formula that will help autofill data. I have a main summary tab where I input all the data and I want it to recognize the names of homes and then autopopulate another tab.

    Here is an image of how my main summary tab looks:

    Capture1.PNG

    So then a second tab would be, for example, "Homes A" which includes Home 1, Home 2, and Home 3 ("Homes B" would be Homes 4, 5, and6, and so on). So if I put "Home 1" in the summary tracking tab, I want the "Homes A" tab to to then be autofilled with the rest of the information that I've put in (Date, person's name, and then the numbers which is the data).

    Basically I'm trying to avoid having to manually copy and paste the information over into the "Homes A" tab each time.

    Not sure if this makes sense, can anyone help?

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula to link cells in different tabs so that they autofill?

    Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

    If you need to post an image post it in the *.jpg format.

    Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

    A SMALL file will be about 10kb in size and have about 20 rows and a few columns worth of data. We should not have to scroll to find the data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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: 2
    Last Post: 11-28-2014, 09:16 AM
  2. Replies: 0
    Last Post: 01-28-2014, 02:45 PM
  3. How do you link cells in workbook tabs?
    By Spiceman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-14-2013, 02:17 PM
  4. Excel Autofill over different tabs
    By Petervanderpol in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2013, 01:50 PM
  5. Replies: 7
    Last Post: 04-21-2012, 08:53 PM
  6. autofill a formula that references worksheet tabs
    By menziesthefish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-29-2010, 10:50 AM
  7. Need a formula to link tabs on a rolling document
    By dpc99999 in forum Excel General
    Replies: 0
    Last Post: 10-11-2009, 07:17 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