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.
Bookmarks