Creating a audit report
Results 1 to 2 of 2

Thread: Creating a audit report
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Creating a audit report

    I AM NEW TO EXCEL AND I AM HAVING TROUBLE WITH A WOOKSHEET I CREATED. ON ONE SHEET I HAVE A DATA PAGE (TABLE) WITH 19 COLUMNS OF DATA. ON SHEET 2 I AM TRYING TO SET UP AN AUDIT PAGE WHERE THE USER CAN HAVE A DROP DOWN MENU OF THE 19 COLUMNS OF DATA FROM SHEET 1 AND BE ABLE TO SELECT WHICH ONE TO POPULATE ON THE PAGE.
    Example
    sheet 1
    name Example data 1 Example data 2 Example data 3

    John smith 1234 9876 3456
    Bill Day 3214 7890 9839
    Jane smith 5432 5678 5436



    Sheet 2 with drop down menu

    Audit report

    Name Example data 1 Example data 3
    John smith 9876 3456
    Bill Day 7890 9839
    Jane smith 5678 5436


    So Example data 1 would be chosen from a drop down menu along with 3. Using Vlookup would take to long because there is 150 to 300 lines of data per column in the actual form.
    I would be grateful for any help I could get. Thanks

  2. #2
    New Member
    Join Date
    Dec 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Creating a audit report

    Sorry the example of sheet 1 and sheet 2 did not populat correctly on mobile version.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •