+ Reply to Thread
Results 1 to 3 of 3

Copy data from worksheet to select worksheets using dropdowns

  1. #1
    Registered User
    Join Date
    10-16-2018
    Location
    Ankeny, Iowa
    MS-Off Ver
    365
    Posts
    2

    Copy data from worksheet to select worksheets using dropdowns

    Hi - I am trying to add another feature to my current excel workbook that I built with help from other forums and the internet.

    I have a workbook that contains several worksheets. One worksheet is labeled "Proposed Travel" and contains two separate dropdown lists. One is Column E which is labeled "Program Code" and the other is Column G, which is labeled "Approved?".

    When I select one of the dropdowns in Column E and then select "YES" from the dropdown in Column G, I want the following data (B6, C6, D6, F6 and H6 on Proposed Travel worksheet) to copy onto the first available line (in Columns A6, B6, D6, F6, and H6) on the worksheet selected in Column E (worksheets starting with either 21000, 21010, 21020, 21030, 21036, or 21070).

    As I go down the list to select "YES" on Proposed Travel Worksheet, I would like data added to next available line on the respective worksheet.

    I am not able to upload the workbook as keep getting message that upload failed. Any suggestions on how I can get it to you would be great!

    Thanks for your time in this matter.

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Copy data from worksheet to select worksheets using dropdowns

    Hiya,

    Would you be able to upload a sample workbook please? It will help us work through your use case and provide assistance

    Edit your post > click "Go Advanced" > "Manage Attachments" > Upload your file(s) > Submit

  3. #3
    Registered User
    Join Date
    10-16-2018
    Location
    Ankeny, Iowa
    MS-Off Ver
    365
    Posts
    2

    Re: Copy data from worksheet to select worksheets using dropdowns

    Thanks for getting back to me. Am unable to upload the workbook as keeps giving me message that upload of file failed. Have attached as ZIP file. Thanks much for taking time to look at this for me.

+ 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] Looping through the worksheets and copy a data to other worksheet
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-21-2018, 08:53 AM
  2. Replies: 2
    Last Post: 07-20-2018, 12:35 AM
  3. Copy Data From Two Worksheets to master Worksheet
    By amithap in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2014, 03:11 AM
  4. Copy Data From 3 Worksheets into a 4th Worksheet
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-06-2013, 08:48 PM
  5. macro to copy data from 3 worksheets in one worksheet
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2013, 11:39 PM
  6. [SOLVED] Copy data from several worksheets to one existing worksheet
    By e.nekram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-22-2012, 07:17 AM
  7. [SOLVED] Copy data from 3rd worksheets and pasting to active worksheet
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-28-2005, 10:06 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