+ Reply to Thread
Results 1 to 5 of 5

Data report from Excel spreadsheet

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    3

    Data report from Excel spreadsheet

    I am now using a mobile app which automatically generates a google spreadsheet. I would like to be able to use this information to show where all our labour is based in an up to date way. The table produces information in separate columns; Site Name, Hours, Date worked, Employee Name, Site Code and would be updated automatically everyday. I would like to have an automatic report by using formulas to show a list of labour on each site within the last week (date to be automatic to stay up to date).

    For example:

    w/ending 10/08/14 Bowerdean 25 Tomasz Williams
    Ben Smith
    Cloncurry 33 Emma Barber

    Any help would be greatly appreciated,

    Emma

    Timesheet data.png

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,827

    Re: Data report from Excel spreadsheet

    Upload Sample workbook without any confidential data showing before & after sheet for better & faster response

    Punnam

  3. #3
    Registered User
    Join Date
    08-08-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    3

    Re: Data report from Excel spreadsheet

    Hi Punnam,

    The attached timesheet shows how the information arrives onto the spreadsheet and this would get longer and longer as information is entered onto the app. Not sure what you mean by an after sheet? The sheet would not be amended as I would like a separate report which lifts the information from the timesheet to show information for the most recent weekending - Site address and labour names,

    Kind regards,

    Emma

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,827

    Re: Data report from Excel spreadsheet

    before sheet show u r present data ,
    After shows u r requirement manually
    All the above said in a excel workbook instead of image will be helpful to under stand & fast response

    Punnam

  5. #5
    Registered User
    Join Date
    08-08-2014
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    3

    Re: Data report from Excel spreadsheet

    Hi Punnam,

    Please find attached, the report doesn't need to be exact but it gives you an idea of the information i am looking to lift from the spreadsheet automatically,

    Kind regards,

    Emma
    Attached Files Attached Files

+ 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. Excel spreadsheet to produce a report per row
    By bankcott in forum Excel General
    Replies: 15
    Last Post: 02-23-2014, 11:11 AM
  2. Macro to Export Data from one spreadsheet to a Report Spreadsheet
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2013, 03:59 PM
  3. [SOLVED] Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 05:10 AM
  4. Replies: 2
    Last Post: 06-29-2011, 04:35 PM
  5. Automate Excel report to place certain data into existing report?
    By Craig Harrison in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2006, 09:00 AM

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