+ Reply to Thread
Results 1 to 4 of 4

Populate Summary Sheet

  1. #1
    Registered User
    Join Date
    01-21-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    16

    Populate Summary Sheet

    Hello All.

    I have 2 requests Im hoping you might be able to help me with.

    On the INPUT sheet of my workbook I wish to search a range of rows for the first cell of each row that has data in it (starting time), and then copy the adjacent data (from cells in row 2) of each of those columns, and paste that data into respective cells on another sheet to Print.

    I'd then like to do the same for the last cell filled in (finishing time).

    Ive attached a part of my workbook, showing what I mean.

    The data is filled in on the Input page (with the x's and the person's name), and I'd like the relevent info for the Summary page taken from that sheet and populated into it for printing.

    I've filled in the start and finish times for the first three to show what I'd like to have done automatically.

    I hope Ive explained it well enough and someone can be of assistance.

    Thank you :-)
    Attached Files Attached Files
    Last edited by ExcelSpreads; 04-20-2016 at 10:20 PM. Reason: Decided the outcome of this request was all I required.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,428

    Re: Populate Summary Sheet

    Something to start with:

    First:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Last:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-21-2016
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    16

    Re: Populate Summary Sheet

    Hi Trevor,

    Thank you so much for that.
    That does just what I was after :-)

    Thanks so much for that
    Last edited by ExcelSpreads; 04-20-2016 at 10:14 PM. Reason: Reconsidered what I was after. This solved my problem

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,428

    Re: Populate Summary Sheet

    You're welcome. Thanks for the rep.

+ 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] Need to Populate the Summary sheet Based on Individaul sheets
    By Kandavalli.Kiran in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 01-28-2015, 12:08 AM
  2. [SOLVED] Populate summary sheet with values within specific month column on data sheet...
    By blue91 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-12-2013, 12:11 PM
  3. [SOLVED] Auto-populate summary sheet... with dynamic info.
    By jhren in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2013, 08:33 AM
  4. Replies: 4
    Last Post: 05-02-2013, 04:39 PM
  5. Populate summary sheet (insert & index rows from info in columns on another sheet)
    By DerbysGal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2011, 01:54 PM
  6. Macro to populate summary sheet
    By endoskeleton in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-03-2011, 06:42 PM
  7. Populate Summary Sheet with same cell from multple sheets
    By ShredDude in forum Excel General
    Replies: 9
    Last Post: 07-16-2007, 08:12 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