+ Post New Thread
Results 1 to 9 of 9
Office Software Thread, Excel Bring Data From Another Sheeting Using Drop Down. in Technical; I am creating a spreadsheet (see attached for sample of what doing). On the welcome sheet I need in c1 ...
  1. #1

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,924
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204

    Excel Bring Data From Another Sheeting Using Drop Down.

    I am creating a spreadsheet (see attached for sample of what doing). On the welcome sheet I need in c1 a drop down box with info from row one on sheet data.

    If select c under drop downbox shows content of column c. If select b get data listed under B.

    Russell

    eg template.xlsx

  2. #2

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,762
    Thank Post
    3,270
    Thanked 1,053 Times in 974 Posts
    Rep Power
    365
    So you have a drop down menu which contains :

    | A |
    | B |

    When you click on A it refreshes with all the items in Column A and the same if you select option B it will refresh with the options in Column B, currently there is no drop down menu in that spreadsheet but I am using 2003 not 2010 or 2007.

    Also once you have selected an option how are you going to make it go back to the original options that were in the drop down ie A, B, C etc ?

  3. Thanks to mac_shinobi from:

    russdev (13th May 2011)

  4. #3

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,924
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204
    That is why asking hope someone had a great idea. The idea is want them to be able to compare what is in d with other data but give them an easy way to select one column at time so that they do not have to keep searching the full data.

    Russell

  5. #4

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,762
    Thank Post
    3,270
    Thanked 1,053 Times in 974 Posts
    Rep Power
    365
    Quote Originally Posted by russdev View Post
    That is why asking hope someone had a great idea. The idea is want them to be able to compare what is in d with other data but give them an easy way to select one column at time so that they do not have to keep searching the full data.

    Russell
    If its just comparing two columns why not make the 3rd column have an if statement or something similar that compares them and if there is a difference highlight the cell in a certain colour ie light blue or green or something ?

    Otherwise it will be right click in ribbon / grey area --> control toolbox --> add combo box --> code in vba for the different events and for the control to do what you need it to.

  6. Thanks to mac_shinobi from:

    russdev (13th May 2011)

  7. #5

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,924
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204
    Quote Originally Posted by mac_shinobi View Post
    If its just comparing two columns why not make the 3rd column have an if statement or something similar that compares them and if there is a difference highlight the cell in a certain colour ie light blue or green or something ?

    Otherwise it will be right click in ribbon / grey area --> control toolbox --> add combo box --> code in vba for the different events and for the control to do what you need it to.

    Thanks I will have a play later...

  8. #6

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,762
    Thank Post
    3,270
    Thanked 1,053 Times in 974 Posts
    Rep Power
    365
    Quote Originally Posted by russdev View Post
    Thanks I will have a play later...
    Will it always be columns A and B or could it be more ?

  9. Thanks to mac_shinobi from:

    russdev (16th May 2011)

  10. #7

    Join Date
    Apr 2007
    Location
    Birmingham
    Posts
    142
    Thank Post
    6
    Thanked 45 Times in 39 Posts
    Rep Power
    22
    I may have misunderstood, but something like this?
    Attached Files Attached Files

  11. Thanks to andy_b from:

    russdev (16th May 2011)

  12. #8

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,924
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204
    Andy you a star that is exactly what I want ...

    Russ


    Edit

    Ok need to work out where doing the proccess for drop down (being stupid on a monday morning). As added in new column called d, added it to the drop down but when select the drop down it gives a ref error?

    eg template (1).xlsx
    Last edited by russdev; 16th May 2011 at 09:44 AM.

  13. #9

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,924
    Thank Post
    709
    Thanked 551 Times in 366 Posts
    Blog Entries
    3
    Rep Power
    204
    Thanks to pm from Andy worked out needed to give new column a name range of column_e.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2007] Excel Does Not Display Data In Spreadsheet
    By DaveP in forum Office Software
    Replies: 2
    Last Post: 30th November 2012, 04:24 PM
  2. [MS Office - 2003] Excel - Creating lists of data
    By gmiller in forum Office Software
    Replies: 3
    Last Post: 1st March 2011, 03:25 PM
  3. Merging data in excel
    By Mr_M_Cox in forum Windows
    Replies: 10
    Last Post: 31st October 2008, 11:43 AM
  4. Datacable or Excel Data Services?
    By harvy28 in forum Hardware
    Replies: 2
    Last Post: 28th April 2008, 11:32 AM
  5. Excel Assesment Data
    By danIT in forum General Chat
    Replies: 2
    Last Post: 14th February 2008, 02:14 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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