+ Reply to Thread
Results 1 to 9 of 9

I need one workbook page to feed selected data to others!

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    England
    MS-Off Ver
    Unknown
    Posts
    4

    I need one workbook page to feed selected data to others!

    Hi,

    I have been asked to design a simple timesheet entry system for how we spend our time on clients.

    It has been requested that on sheet one that we are able to select a client name or code from a dropdown box, enter our start and finish times, and an optional note.

    We need it to then automatically pull that data to the correct corresponding sheet for that client, so we can subtotal monthly how much time we have spent on them.

    I have attached the bare bones of what we have so far, I hope someone can help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: I need one workbook page to feed selected data to others!

    Hello
    Perhaps an easier solution than creating sheets for each client would be to have a single entry table and then a pivot table to analyze the data for each client, or do you have to have your current layout?

  3. #3
    Registered User
    Join Date
    05-26-2015
    Location
    England
    MS-Off Ver
    Unknown
    Posts
    4

    Re: I need one workbook page to feed selected data to others!

    Not necessarily, if a pivot table would easily show how many hours by client

  4. #4
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: I need one workbook page to feed selected data to others!

    Okay, I'll upload an example for you to consider. Give me a few minutes.

  5. #5
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: I need one workbook page to feed selected data to others!

    What version of Excel are you using?

  6. #6
    Registered User
    Join Date
    05-26-2015
    Location
    England
    MS-Off Ver
    Unknown
    Posts
    4

    Re: I need one workbook page to feed selected data to others!

    Excel 2010 currently

  7. #7
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: I need one workbook page to feed selected data to others!

    Here's an example Pivot table option.
    Attached Files Attached Files

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    2016
    Posts
    3,836

    Re: I need one workbook page to feed selected data to others!

    Please check the attached file hope this will help you.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    05-26-2015
    Location
    England
    MS-Off Ver
    Unknown
    Posts
    4

    Re: I need one workbook page to feed selected data to others!

    Many thanks! Just need to get a list of our clients as a drop down box now and im away!

    Many thanks

+ 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] Creating a Summary Page of Selected Data Lines from multiple worksheets in same workbook
    By MrNightly in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-15-2014, 01:07 PM
  2. Loop through data on a workbook, selected it and paste in current workbook
    By concatch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2012, 08:59 AM
  3. Paste data from excel to word ON SELECTED PAGE
    By papasideris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-24-2012, 10:20 AM
  4. A query sheet to feed central workbook.
    By willhollis18 in forum Excel General
    Replies: 0
    Last Post: 10-11-2009, 08:55 AM
  5. [SOLVED] Pulling selected data from a detail page to a summary
    By Redline in forum Excel General
    Replies: 2
    Last Post: 01-16-2006, 12:10 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