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.

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

"Murph" wrote:

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.

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)
--
Sparkle


"Murph" wrote:

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.

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

"Sparkle" wrote:

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)
--
Sparkle


"Murph" wrote:

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.