Results 1 to 10 of 10

Conditional copy to list

Threaded View

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

    Conditional copy to list

    Hi,

    I need to form a list of text (column A) and corresponding numeric values (column B) whereby the list values are placed in the next unused cell in these columns when the worksheet is updated. Placing values in the list is based on finding a TRUE value in column E.

    The logic for this goes as follows:

    If the value in cells E44:E1445 is true then copy the corresponding text value from the range C44:C1445 into the next unused cell in column A starting at cell A44.

    and

    if value in cells E44:E1445 is true then copy the corresponding numeric value from the range E44:E1445 into the next unused cell in column B starting
    at cell B44.

    Can anyone in the forum help with this logic?

    Thanks,

    Art
    Last edited by ArtZ; 01-06-2009 at 01:43 PM.

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