I face with problem in Excel. The problem is I have a 3 sheets I need to transfer from one sheet to another sheets data.

For Example: I have a data in colums A B C D and E. In column E I have digits positive or negatives and I need to transfer data in columns A B C D to near and far sheets if in column E number is position transfer A B C D data to near Sheet else to far sheet. enter image description here

How to do it. Does anyone know it? please help me!

Thanks a lot!!!

CodePudding user response：

For positive values use-

=FILTER(Sheet1!A:D,Sheet1!E:E>0)

For negative values use-

=FILTER(Sheet1!A:D,Sheet1!E:E<0)