+ Reply to Thread
Results 1 to 9 of 9

Creating Data on New Page from Reference Cell

Hybrid View

  1. #1
    Registered User
    Join Date
    06-09-2015
    Location
    Kentucky, US
    MS-Off Ver
    2013
    Posts
    9

    Question Creating Data on New Page from Reference Cell

    Hello all!

    I am not entirely sure what thread this might fall under but I figured that starting here might result in someone pointing me in the right direction.

    I am creating a database workbook, and I have many pages that I would like to pull data from to consolidate in a summary of sorts. However, these data pages all have varying amounts of data in multiple entries and no two entries are the same length. Basically, I'm working with data from different screening events where any number of participants are present.

    I am hoping to create a separate summary page with some summary data and I am hoping that I can do this in a very particular way. I have summaries already on the data pages but I want them to also be on the summary page. Is there anyway that I can have a reference point column on the summary page where all I need to do is input a reference point cell from a different page and it will correctly pull the data into the summary page? That way, I'm not double entering data? The problem is, I can't give a specific instruction like 'pull data from every 23rd cell down in this column' because all the entries are separate lengths.

    I get that it's a bit ridiculous and I would be more than happy to clarify, but I am just wondering if this is a possibility and if so, how to accomplish it.

    Thanks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Creating Data on New Page from Reference Cell

    Hi there... and welcome to the Excel Forum. I thik that we need to see something...Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    06-09-2015
    Location
    Kentucky, US
    MS-Off Ver
    2013
    Posts
    9

    Re: Creating Data on New Page from Reference Cell

    Thanks Glenn. I will mock something up right now and post it very shortly!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Creating Data on New Page from Reference Cell

    OK. What you're asking for sounds impossible... but we'll see!!

  5. #5
    Registered User
    Join Date
    06-09-2015
    Location
    Kentucky, US
    MS-Off Ver
    2013
    Posts
    9

    Re: Creating Data on New Page from Reference Cell

    So I have attached a sample database. The Individual Data Sheet is an example of the data I'm working with but there are usually 30 to 40 tables per page. They all have different numbers of participants show up, from 7 to over 300. What I want to do is pull the existing summary information from my summary tables and put it on the (vastly underdeveloped currently) Screening Event Data Sheet.

    However, I don't want to type everything over again because we have a lot of data coming in pretty continuously. On my Screening Event Data Sheet, there is the Reference Point column. Ideally, I'd like to give that column one cell for each table and it pulls the rest of the data accordingly. Can excel do that?

    Thanks again, all.
    Attached Files Attached Files
    Last edited by jcri227; 06-09-2015 at 12:24 PM.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Creating Data on New Page from Reference Cell

    Like this, maybe??
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-09-2015
    Location
    Kentucky, US
    MS-Off Ver
    2013
    Posts
    9

    Re: Creating Data on New Page from Reference Cell

    GLENN! YOU ROCK!

    This is exactly what I need. The only hiccup (or hiccough, depending on how you roll), is that some events fall on the same date despite being distinct. Can I do what you did using only the name? I would certainly hope so. Also, did I say? GLENN, YOU ROCK.

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Creating Data on New Page from Reference Cell

    I guess we can - but can you explain where the problems are?

  9. #9
    Registered User
    Join Date
    06-09-2015
    Location
    Kentucky, US
    MS-Off Ver
    2013
    Posts
    9

    Re: Creating Data on New Page from Reference Cell

    I think I have it sorted actually. Seeing it all written out sometimes helps me get there. Thanks so much for your help!

+ 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: 5
    Last Post: 08-13-2013, 09:03 AM
  2. Changing page reference for specific data set.
    By dfresh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2012, 10:41 AM
  3. Creating a summary page of populated data
    By bigmattiet in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 09:57 PM
  4. Reference cell from top row of each page in header
    By mzemble in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2009, 12:45 AM
  5. Data in cell to reference a worksheet page
    By eklarsen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-15-2005, 06:52 PM

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