+ Reply to Thread
Results 1 to 2 of 2

Copy cells based on dropdown selection

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    Arizona
    Posts
    28

    Copy cells based on dropdown selection

    Hey all,
    Im trying to figure out how to copy a gropu of cells based on what is selected from a dropdown menu.

    On the attached spreadsheet, i would like for the selection in cell C44 to determine what will be copied to cell A46. The drop downs come from cells E48:E51. If same route back is selected i would like for cells E54:F54 to be copied. If new route or destination is selected i would like cells E57:G98 copied and the total to add in previous totals.

    If this is possible without to much hassle/programming it would be great, but expecting a bit of work/programing knowledge to get this done.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-02-2008
    Location
    India
    Posts
    118

    Re: Copy cells based on dropdown selection

    Umm... i'm guessing it cud be possible by lookups... but need to see the sheet... I'm on excel 2003... actually there shud be some guidelines for ppl in this regard... so non-priviliged users like me cud also work on or atleast view 2007 based sheets.... as these problems and issues really help alot in understanding and learning new tricks!

    Can something be worked out?

    Regards

    Mohit

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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