Results 1 to 4 of 4

Thread: Help newbie to excel
Thanks Thanks: 0 Likes Likes: 0

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

    Question Help newbie to excel

    First of All Hi to All out there in MRExcel world.

    I am fairly new to excel and I have been tasked with a pig of a query, I need to automate a report in one spread sheet to draw data from certain cells on tabs in another spread sheet held on a server.basically the report has to show the tonnages from a weekly (1 -52) from three cells Quay, Road & Rail.

    What I would like to do is create a dropdown menu for weeks 1 - 52 in one cell in the report so that if I pick a week it will link the corresponding tab/cells in a separate workbook, to the cells in the report.

    I had looked at '=indirect' statement but I have struggled to get this to work.

    Any help in this will be greatly appreciated.

    Regards & Thanks

    Darren

  2. #2
    Board Regular
    Join Date
    Apr 2004
    Posts
    7,896
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help newbie to excel

    try posting a sample of your data, and what you would like to do with it
    Yesterday I felt on top of the world. Today its falling in on me.

  3. #3
    New Member
    Join Date
    Oct 2017
    Location
    Hull UK
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help newbie to excel

    stand alone workbook
    When you choose the week 1,2,3 etc as adrop down menu. I would like to link to 'Test' spread sheet to show the totaldetails in cells b4,c4 & d4.
    WEEK1
    road rail quay
    ----------------------------------------
    separate workbook
    week 1
    road rail quay
    600.256 1000.156 1501.106
    750.256 1120.156 1601.106
    550.256 1350.156 1901.106
    200.256 1500.156 901.106
    Total 2101.024 4970.624 5904.424
    ----------------------






    week 2
    road rail quay
    500.256 2000.156 1901.106
    850.256 2120.156 1801.106
    750.256 1550.156 1701.106
    900.256 2300.156 1801.106
    Total 3001.024 7970.624 7204.424
    --------------

    week 3
    road rail quay
    550.256 2100.156 1901.106
    875.256 2010.156 1701.106
    7460.256 1850.156 1901.106
    1200.256 2600.156 1901.106
    Total 10086.02 8560.624 7404.424
    Thankyou

  4. #4
    Board Regular
    Join Date
    Apr 2004
    Posts
    7,896
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help newbie to excel

    ok, could you add a column to hold the week number immediately before your totals? (could be hidden if required)

    send me a pm with your email, and I can send a worked example
    Last edited by SteveO59L; Oct 11th, 2017 at 04:24 AM.
    Yesterday I felt on top of the world. Today its falling in on me.

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
  •