+ Reply to Thread
Results 1 to 8 of 8

Creating a Front Sheet that pulls it's information from other sheets in the workbook

  1. #1
    Registered User
    Join Date
    08-14-2019
    Location
    Somerset, England
    MS-Off Ver
    Excel 2016
    Posts
    4

    Creating a Front Sheet that pulls it's information from other sheets in the workbook

    I am looking to create a front sheet for an Excel Workbook capable of pulling rows of information from other sheets in the Workbook, based on whether specific cells have/don't have anything entered in them.

    Is this possible?

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    It is possible for sure. Depending on your data layout and what you need to pull, you can use VBA or formulas
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    08-14-2019
    Location
    Somerset, England
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    Do you have an example of a formula that could be used? The rows of data I want to pull are are 8 cells long and would be based on the last cell having text in or being blank

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    Hello josh_horley14 and Welcome to Excel Forum.
    It may help if you could upload a small desensitized sample of your workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    I would also suggest that if you are pulling rows from more than a couple of sheets, that you ask the moderator to move this thread to the VBA forum.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    08-14-2019
    Location
    Somerset, England
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    I've attached the sample workbook to this reply, if anyone could take a look at it for me I would appreciate it. I don't know who to ask to move it over to the VBA forum.
    Attached Files Attached Files

  6. #6
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    Compile some example in sheet1 based on sheet 2. To use formulas you need a link key between pages, like category name.
    I am asking as I fail to understand why you would keep lines of data with same headers in the same row and not adding them one under another.

  7. #7
    Registered User
    Join Date
    08-14-2019
    Location
    Somerset, England
    MS-Off Ver
    Excel 2016
    Posts
    4

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    Try this attachment?
    Attached Files Attached Files

  8. #8
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Creating a Front Sheet that pulls it's information from other sheets in the workbook

    I assume from post #3 that the "last cell" is in the "Sent To" column.
    I also assume that if there is some text in that column that you want the Category, Date Received, Date Due Back, Commander, Inspector and Date Inspection Complete to be placed in a table like the one on Sheet1.
    If these assumptions are correct you may be able to use Get & Transform found on the Data tab to produce a append table such as All_Tables found on sheet 3.
    A connection only is made to the three tables on Sheet 2 then the three connections are then appended.
    The columns that you want to see are left unhidden with the exception of the Sent To and Sent To 2 columns which are grouped so that you can select the filter from the Sent To column.
    Let us know if you have any questions.

+ 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. Creating a formula that pulls information off of many duplicated sheets
    By nrsensabaugh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2017, 06:52 PM
  2. Replies: 0
    Last Post: 07-27-2016, 07:58 AM
  3. [SOLVED] Creating a Text box that pulls info from cell in another sheet.
    By llamafarmer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2016, 04:56 PM
  4. Replies: 6
    Last Post: 08-09-2013, 01:49 PM
  5. [SOLVED] Housekeeping payroll that pulls rows of information to different sheets
    By alphonse in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-29-2013, 09:45 AM
  6. [SOLVED] Auto Macro the pulls data from on sheet, prints on another sheet, then deletes information
    By wjwelch1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-06-2013, 01:54 PM
  7. Replies: 0
    Last Post: 05-11-2010, 08:24 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