Results 1 to 12 of 12

Thread: Excel Help Needed

  1. #1
    DR
    DR is online now
    on ye old ship HEXUS DR's Avatar
    Join Date
    Jul 2003
    Location
    HEXUS HQ, Elstree
    Posts
    13,411
    Thanks
    1,058
    Thanked
    831 times in 372 posts

    Excel Help Needed

    If anyone is really good with Excel could they get in touch.

    I want to be able to have a drop down menu which is on the page which lists all my other pages in my workbook - allowing me to select one and pull a certain data set over from that and put it on the front page. So I can compare data

  2. #2
    DR
    DR is online now
    on ye old ship HEXUS DR's Avatar
    Join Date
    Jul 2003
    Location
    HEXUS HQ, Elstree
    Posts
    13,411
    Thanks
    1,058
    Thanked
    831 times in 372 posts
    so 10 cells from sheet 2, ten from sheet 3 all on to sheet 1

  3. #3
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts
    hmm, been scratching my noggin but can't come up with an idea, i was thinking of using the ADDRESS function, but you can't navigate sheets relativily.

    Can you use VBA, its easy in that.
    throw new ArgumentException (String, String, Exception)

  4. #4
    Senior Member
    Join Date
    Oct 2005
    Posts
    320
    Thanks
    3
    Thanked
    1 time in 1 post
    not a very elegant solutiuon, but create a drop down box from the forms

    Create a new worksheet
    In a1 put sheet 1
    a2 "sheet2"
    a3 "sheet3" etc

    Modify the properties of the dropdown box and in the control tab the input range is column a

    Cell link should be a random cell hidden off sheet somewhere, say b1

    In the cells that you want to reflect your 10 cells have an if statement reflecting if b1=1 then list cells in sheet1

    poorly explained, i'll try to create a sheet now for you

  5. #5
    Senior Member
    Join Date
    Oct 2005
    Posts
    320
    Thanks
    3
    Thanked
    1 time in 1 post
    hmm, can't do attachments here...

    edit emailed to david.ross@hexus.net
    edit 2: my email server has died :/
    Last edited by pak000; 24-04-2006 at 12:19 PM.

  6. #6
    DR
    DR is online now
    on ye old ship HEXUS DR's Avatar
    Join Date
    Jul 2003
    Location
    HEXUS HQ, Elstree
    Posts
    13,411
    Thanks
    1,058
    Thanked
    831 times in 372 posts
    Not got it yet Pak000

  7. #7
    Senior Member
    Join Date
    Oct 2005
    Posts
    320
    Thanks
    3
    Thanked
    1 time in 1 post
    hopefully you'll have it now, my main mail server appears to be having a fit, used gmail instead

  8. #8
    Senior Member
    Join Date
    Oct 2005
    Posts
    320
    Thanks
    3
    Thanked
    1 time in 1 post
    As a better explaination, based off the created sheet....

    Cells in column C (minus the header) appear in the drop down menu, this is defined in the properties of the menu box

    cell e9 is set in the properties of the dropdown box to reflect which menu item is selected, 1 being the first from the list, 2 the 2nd etc

    You can hide the above on another sheet to keep your main one tidy as they are just checks

    By using recursive if statments in the areas you want to change depending on what is shown in the drop menu you can change the information..

    following excels if format... If(statement, if statement true, if false)
    If(e9=1,display value of other sheet, if(e9=2, display value of sheet2,further if statment))

  9. #9
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,164
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts
    you can't completely enumurate them can u?

    in vba you can
    Code:
    For Each w In Worksheets
        Debug.Print w.Name
    Next w
    throw new ArgumentException (String, String, Exception)

  10. #10
    HEXUS.social member Allen's Avatar
    Join Date
    Nov 2003
    Location
    Brighton
    Posts
    8,536
    Thanks
    363
    Thanked
    262 times in 168 posts
    • Allen's system
      • Motherboard:
      • ASUS Maximus VIII Gene
      • CPU:
      • Intel Core i5 6600K
      • Memory:
      • 2 x 8GB Kingston HyperX Predator DDR4-3000
      • Storage:
      • 256GB Samsung 950 PRO NVMe M.2 (OS) + 2 x 512GB Samsung 960 EVO in RAID 0 (Games)
      • Graphics card(s):
      • ASUS ROG Strix GeForce GTX 1080 Ti OC
      • PSU:
      • XFX P1-650X-NLG9 XXX 650W Modular
      • Case:
      • Fractal Design Node 804
      • Operating System:
      • Windows 10 Home 64-bit
      • Monitor(s):
      • 27" BenQ XL2730Z + 23" Dell U2311H
      • Internet:
      • Virgin Media 200Mbps
    Quote Originally Posted by David
    If anyone is really good with Excel could they get in touch.

    I want to be able to have a drop down menu which is on the page which lists all my other pages in my workbook - allowing me to select one and pull a certain data set over from that and put it on the front page. So I can compare data
    Quote Originally Posted by David
    so 10 cells from sheet 2, ten from sheet 3 all on to sheet 1
    So, you want 2 drop down menus on the front page which can select 2 of the worksheets in your workbook and pull info from those worksheets and put them into a table on the front page for you to compare the date?

    If the data is not sensitive feel free to e-mail it to me: allenparishuk at yahoo dot co dot uk

    Otherwise, lemme see what I can come up with.

  11. #11
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    275 times in 146 posts
    was mucking around - what about using a pivot table consolidation, with the Page field dropdown providing data from specific sheets? Could use any function really, if single values

    a thought - works on the example I just drew up
    Last edited by fuddam; 24-04-2006 at 01:32 PM.

  12. #12
    Senior Member
    Join Date
    Oct 2005
    Posts
    320
    Thanks
    3
    Thanked
    1 time in 1 post
    Have just been thinking about the sample i sent back to you david....It will be much easier to use MS access, or some database software, you could then generate pretty forms reports too

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Pro Needed
    By theuncharmed in forum Software
    Replies: 6
    Last Post: 14-03-2006, 10:10 PM
  2. M$ Excel masters..
    By XA04 in forum Help! Quick Relief From Tech Headaches
    Replies: 9
    Last Post: 19-09-2005, 10:48 AM
  3. Replies: 6
    Last Post: 12-08-2005, 08:50 AM
  4. Excel - Office XP
    By KDH in forum Software
    Replies: 0
    Last Post: 04-08-2004, 11:08 PM
  5. Radeon 8500 linux driver install problems
    By Dorza in forum Software
    Replies: 0
    Last Post: 22-09-2003, 12:00 PM

Posting Permissions

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