+ Reply to Thread
Results 1 to 6 of 6

Help with basic table

  1. #1
    Registered User
    Join Date
    04-16-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    2

    Help with basic table

    Hi Folks,

    I just need help setting up a basic excel sheet - I have a program which extracts the following data to a excel spreadsheet

    ID NAME START END CAR
    12 Lee 19/04/2024 17:15 24/04/2024 17:15 Toyota
    13 Joe 19/04/2024 11:00 22/04/2024 8:00 suzuki
    14 Mike 19/04/2024 8:00 19/04/2024 17:00 kia
    15 John 19/04/2024 10:00 19/04/2024 16:00 ute

    I'd like to have this automated into another sheet I have setup where the values and stuff are setup on our company sheets.
    This is not the same cell placement etc, how can I set this up??

    Thanks

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Help with basic table

    Try to upload a sample worksheet.
    Quang PT

  3. #3
    Registered User
    Join Date
    04-16-2024
    Location
    Australia
    MS-Off Ver
    365
    Posts
    2

    Re: Help with basic table

    Sure, uploaded example.

    So in the Data sheet is the information extracted and in the Print sheet is what I want to be able to setup and autofill cells depending on what is selected.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: Help with basic table

    Would something like the attached work for you. Using VLOOKUP formula based on the ID selected on the Data sheet.

    Example of vehicle formula:

    =VLOOKUP(Data!H2,Data!A:E,5,FALSE)
    Attached Files Attached Files
    Last edited by AliGW; 04-17-2024 at 01:45 AM. Reason: Formula added.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,000

    Re: Help with basic table

    Administrative Note:

    Where you have provided a workbook solution, please also include a clear explanation of what you've done and how (including formulae/code as approriate) in the post in question (for the benefit of members unable to download attachments).

    This is about making your assistance accessible to all. I've done it for you this time.

    Thanks.
    Last edited by AliGW; 04-17-2024 at 01:46 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: Help with basic table

    Noted. Thanks AliGW for inserting.

+ 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] My basic table doesn't group and sum
    By mr_jules in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-10-2017, 09:04 PM
  2. [SOLVED] Basic Pivot Table Help
    By Karen615 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-21-2014, 11:25 AM
  3. help creating basic pivot table...
    By yertleturtle in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-18-2014, 12:22 PM
  4. Basic table lookup
    By mys Scott in forum Excel General
    Replies: 2
    Last Post: 09-27-2011, 01:23 PM
  5. Reporting from a basic table
    By mamann in forum Excel General
    Replies: 2
    Last Post: 11-06-2009, 09:13 AM
  6. basic pivot table help really needed
    By sam.m in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-16-2009, 04:23 PM
  7. Basic Pivot Table Questions
    By shadestreet in forum Excel General
    Replies: 1
    Last Post: 04-14-2006, 07:25 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