Previous Topic Next Topic

Help! new to excell

Closed
mike - 9 Feb 2010 à 15:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Feb 2010 à 15:46
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Feb 2010 à 15:46
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, "")

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses