+ Reply to Thread
Results 1 to 4 of 4

Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry

  1. #1
    Registered User
    Join Date
    05-28-2015
    Location
    Des Moines, IA, USA
    MS-Off Ver
    Office 2010
    Posts
    3

    Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry

    Another "newby" here. I found the following link that almost solves my problem:

    http://www.excelforum.com/excel-prog...own-entry.html

    This VBA code is simply to post one row from one spreadsheet to another. I copied the code to my file and it worked fine. But I need to modify the codes slightly to NOT copy the entire row, but simply selected cells within the row to the new spreadsheet.

    In the attached file, the first "Expenses" sheet has the following columns: "Expenses", "Amount", "Company", "Address", "City / State / Zip", "Phone", and "First Call?" IF "First Call" = "Y" (drop-down), then only the following selected columns of the "Expenses" sheet should be copied to the appropriate columns of "Sheet2": "Expenses", "Company", "City / State / Zip", "Phone". Again, those selected columns are copied to the other sheet, and ONLY if the "First Call" = "Y". Here's the file:
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry

    thanks for starting the new thread

    do you want to keep the row you copy across or delete it?

    you are right, idea is the same as other sheet

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-28-2015
    Location
    Des Moines, IA, USA
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry

    Oh, absolutely beautiful!! Thank you SO very much!! And I will mark this thread as solved. (Oh, and, no, I did not want to delete the row from the original sheet.)

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry

    i have blocked that line out in the file just in case you wanted to keep it
    in your final version you can just leave it out completely

    Cheers
    Hum

+ 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] Macro to move Entries between Worksheets based on Drop-down Entry
    By PANDACHAN in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-09-2015, 08:50 PM
  2. Replies: 2
    Last Post: 01-12-2015, 02:27 AM
  3. Replies: 14
    Last Post: 08-10-2013, 04:07 PM
  4. Modify Macro to Distribute Output Entries into Separated Worksheets
    By Seraph122 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2013, 08:25 PM
  5. Modify code to show message box on duplicate entry
    By twofootgiant in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-24-2011, 07:50 AM

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