+ Reply to Thread
Results 1 to 1 of 1

Copy data from C3:I3 if R3=TRUE

  1. #1
    Registered User
    Join Date
    03-09-2011
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Copy data from C3:I3 if R3=TRUE

    Hi i have a simple problem that i can’t solve. The idea that i have random numbers from C3:I3 and i want those number being copied lets say in sheet 2 if R3 reads TRUE. R3 comes from a set of conditions and it either prints TRUE or FALSE each time the calculation is updated. The idea is that all those number for which R3 reads true needs to be copies to sheet 2. The random numbers also exists every 3 rows (C6:I6 being the next one) so each time the corresponding R column reads TRUE i want the numbers to be copied to sheet 2. The pasted values in sheet 2 doesn’t have to be in any order as long as it is not overwritten when the R column reads TRUE the second or so on times. So how can i do this any help will be greatly appreciated.

    P.S: the random numbers in the rows are created using the RAND function so it changes after each calculation and that is why R column can read true or false but i need it only for the number that reads true.
    I have attached the excell file just ncase anyone needs to look at it.
    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)

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