Hello:
Please refer to attached file.
I have excel file with data from A1:T31.
I need a VB macro or Formula to do the following:
Need to check the value in column L.
If value is greater then zero then copy corresponding cell from N:T in sheet2 as shown.
In the attached example since L2 > 0 then i would need to copy and paste in Sheet2 at A2
In the attached example since L3 = 0 then skip.
In the attached example since L4 > 0 then i would need to copy and paste in Sheet2 at A3
asn so on...
Let me know if you have any questions.
Thanks.
Bookmarks