Help! new to excell [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i have an excell spread sheet with multipule sheets open. i need to select certain rows of information, copy the info and tell that information where to appear on another sheet or multipule sheets.
i was trying the if command. =if g4>0,"a4:d4", which gets me the info i need but how do i tell it to go to another
cell in another sheet?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am not too sure what you want but it seems to me what you need is to make the call in the other sheet to check the value and if condition passes, show the value

some thing like

=if('Shee1'!g4> 0, 'sheet1!g4, "")

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!