+ Reply to Thread
Results 1 to 4 of 4

Copy cell value to list with command button click

  1. #1
    Forum Contributor
    Join Date
    01-07-2006
    Location
    San Jose, CA
    MS-Off Ver
    2007, 2016
    Posts
    115

    Copy cell value to list with command button click

    Following a sort procedure I have data in cells C32 and P32 that I may want to copy into lists in columns U and V respectively depending on the data value using a click of a command button. If the cell is populated, the data should be placed in the next blank cell in the rows.

    Can someone help with VBA code that will copy the values over to the target cells starting at U2 and V2?

    Thanks,

    Art

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Can you post a .zip sample of the file?

  3. #3
    Forum Contributor
    Join Date
    01-07-2006
    Location
    San Jose, CA
    MS-Off Ver
    2007, 2016
    Posts
    115
    Thanks for your repsonse. Unfortunately, even zipped, the file is 542kb, exceeding the post size limit. Any other suggestions?

    Art

  4. #4
    Forum Contributor
    Join Date
    01-07-2006
    Location
    San Jose, CA
    MS-Off Ver
    2007, 2016
    Posts
    115
    I reduced the data set size enough to get within the forum limits. Here's the file. -Art
    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. Making cell values correspond with Drop down List values
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2008, 03:14 AM
  2. Need an iterative cell entry and print for entire list of values.
    By jwhitwell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2008, 01:22 PM
  3. Replies: 1
    Last Post: 04-28-2008, 03:30 AM
  4. Cell Copy and Paste to another cell, opposite sign (+/-)
    By excel_man in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2007, 09:41 AM
  5. Copy cell contents and formatting
    By garyk007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2007, 12:14 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