Hi, I am trying to figgure out how to transfer some Data from one table into another based on the cell contents...
I have Sheet 1 which contains all of my raw data and i want to populate Sheet 2 based on if the values in 'Sheet 2 column T' are > 0.
The problem that i seem to be having is whenever i use an IF formula i find that the rows where the 'Sheet 1 Column T' are <=0 are still being populated but are returning the "False" part of the IF formula where instead i want it to skip to the next one that is true.
So IF a row in 'Sheet 1 Column T' >0 then in Sheet 2 i would like the data transfered from their respective sheet 1 columns to their respective sheet 2 columns as below:
Sheet 2
A B C D E F G H I J K L
Sheet 1
C A K L M N O P Q R S T
If this is possible any help would be greatly appreciated.
Bookmarks