Results 1 to 3 of 3

Automatically copy values based on unique/new criteria from a range

Threaded View

djarcadian Automatically copy values... 05-29-2013, 08:40 PM
arlu1201 Re: Automatically copy values... 05-31-2013, 01:17 PM
djarcadian Re: Automatically copy values... 05-31-2013, 08:45 PM
  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Automatically copy values based on unique/new criteria from a range

    I would like to automatically copy the unique values from a range. For example, C22:C30 contain values copied from C32:C50. When a new value appears within the C32:C50 it is automatically copied over to the next available cell within the C22:C30 range.

    I've attached a spreadsheet illustrating what I want to do. The values in cell have been copied over. Ideally as new values appear within the lower rows they would be copied over. So if done correctly the values in the lower green cells would be copied over to blank green cells. Ideally, I would like the system to automatically add rows as needed instead of having to maintain a range of blank cells for it to use.

    I think an easier way to say this is that every time a new value appears within C32:C50 it is copied over to the next available cell within the C22:C30 range. I would also like it to automatically had new rows as new values are found.
    Attached Files Attached Files

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