+ Reply to Thread
Results 1 to 1 of 1

Using VBA code to auto-populate sheets, but drop down list isn't passed through

  1. #1
    Registered User
    Join Date
    11-09-2017
    Location
    Kansas City, MO
    MS-Off Ver
    Office 2010
    Posts
    1

    Using VBA code to auto-populate sheets, but drop down list isn't passed through

    I am definitely not an Excel expert, but I'm trying to set up a spreadsheet that allows for multiple departments enter their data. The first department (IGM) enters data that is then populated onto each of the remaining department's sheets. The IGM sheet includes a column that is restricted to choices from a drop down list. I set up the drop down list by creating a table on a separate sheet which will eventually be hidden - Lookups - and then set up a Data Validation to pull the options.

    Then to auto-populate the rows onto the other department sheets, I used the following VBA code:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Range("IGMUpdate"), Target) Is Nothing Then
    'Sheet5 has purposely been placed first as this will
    'be the active sheet we will work from
    Sheets(Array("IGM", "EBS", "IP", "Litigation Support", "Accounting")).Select
    Else
    Me.Select
    End If
    End Sub

    The script functioned exactly as I was hoping and everything I input on the IGM sheet is populated onto the other department sheets - EXCEPT, the selection from the drop down list. That cell is left blank on the other department sheets.

    Can anyone explain what I'm doing wrong? Is there some other way to accomplish what I'm trying to do? I can always remove the drop down list and just have the cell be free-form, but it's a cell that is used as a trigger by other departments so I really didn't want to leave any room for error/creativity.

    I've included my spreadsheet as an attachment - any help is GREATLY appreciated!
    Attached Files Attached Files

+ 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. [SOLVED] Auto-populate cells based on drop down list selection
    By sh1483 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2016, 11:59 PM
  2. Replies: 3
    Last Post: 01-28-2015, 01:09 AM
  3. Trying to auto populate cells from drop down list choices
    By textexpress in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2013, 12:47 PM
  4. Replies: 2
    Last Post: 08-13-2013, 05:27 PM
  5. [SOLVED] Auto populate adjacent cells from a drop down list
    By gluktar in forum Excel General
    Replies: 4
    Last Post: 06-05-2012, 04:18 PM
  6. Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  7. Drop Down List Auto Populate Percentage in Different Cell
    By quantum17271 in forum Excel General
    Replies: 1
    Last Post: 11-11-2011, 06:39 PM

Tags for this Thread

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