copying cells to another worksheet

[Murph]

trying to copy the value from I3 - M3 from sheet 1 to cell N3 on sheet 2.

I am not trying to add the values together, there will be only one cell
filled in for I3-M3, (I3,J3,k3,l3,m3) and I want that value to be placed in
cell N3 on sheet 2.

Thanks again for all your help.

 

[Alok]

Murph

Try this. It will only work if the value that you place in I3 to M3 on
sheet1 is a numeric value. Also this formula will display a blank if you have
eiter zero or more than one cells with value

=IF(COUNT(Sheet1!I3:N3)<>1,"",MIN(Sheet1!I3:N3))

Alok Joshi

 

[Sparkle]

Hi could u please help me to access every sheet in a workbook through a key
board shortcut key or some combinations of it(apart from ctrl+page down and
ctrl+page up)

 

[Alok]

Hi Sparkle
Since your question is not related to the thread, can you please post it
under a new thread (with an relevant and explanatory title) and I am sure
someone will reply to it. In this thread it will get missed.
Alok