+ Reply to Thread
Results 1 to 4 of 4

Completing a range of cells based on data on another sheet prompted by dropdown selection

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Completing a range of cells based on data on another sheet prompted by dropdown selection

    First sheet has a client name and several cells of data along the same line. All of the data on this sheet is kept long term.

    The second sheet is completed copied and deleted. In completing the second sheet the client name is selected of a drop down list and pulled from sheet one.

    What I want to do and not sure if there is a way is that when I select a client and populate it on sheet two I would like the related data on that clients line from sheet one to populate to same named lines on sheet two.

    Can someone advise if this is possible and if so provide a brief description of how it would work

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,536

    Re: Completing a range of cells based on data on another sheet prompted by dropdown select

    Use VLOOKUP


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Completing a range of cells based on data on another sheet prompted by dropdown select

    Thanks I will look at a tutorial on that

  4. #4
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    221

    Re: Completing a range of cells based on data on another sheet prompted by dropdown select

    I may have some questions as I go through this process, hope that's ok?

    I will see if I can explain this clearly..

    One sheet 1 the first column is the client name and one piece of information is a number call DR (Dock Receipt). On sheet 1 a client can be listed several times each with a different DR.

    On sheet 2 there will be a drop down to enter the client name and this comes from the first column in sheet 1. Also on sheet two are 10 cells to list the DR's for that customer, one or more may be used depending on how many times the customer shows on sheet 1.

    My intent is to be able to select the client and then I will use vlookup to pull the data across. If the client is listed only once this does not present any problem however when the client is listed 2 or more times I am not sure how this will work or if it can.

    First with the DR's can a formula be made to pull the DR's associated with the client name and post each different one to one of the next open of the 10 available cells?

    Second let's say CF (cubic feet). On sheet 2 I want the total CF of all lines on sheet 1 associated to the client to come to sheet 2 as a single total and entry to one cell?

    Can you offer any advise on if this can be done using vlookup or another tool?

+ 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. Replies: 1
    Last Post: 01-17-2014, 04:00 PM
  2. Modify formulas on the entire sheet based on dropdown selection
    By robolist in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2013, 07:22 AM
  3. Replies: 3
    Last Post: 02-24-2011, 01:48 AM
  4. How to lock few cells based on a selection from dropdown
    By sashikanth2274 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2010, 04:36 PM
  5. Copy cells based on dropdown selection
    By wcnwzrd in forum Excel General
    Replies: 1
    Last Post: 10-16-2009, 01:48 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