Copying data from sheet to sheet.
 

I am trying to copy data (value only) from shh1!a1 to sh2!a3. When I put
=sh1!a1 in sh2!a3 it also copies to sh1!a3. If I delete sh1!a3 it deletes
sheetsh2!a3. I would like changes in sh1!a1 to reflect in sh2!a3.
Thanks.

Copying data from sheet to sheet.
 

You have inadvertently selected sheets 2 and 3 and they're working as a
group. Right click on either Sheet 2 or Sheet 3 and Ungroup Sheets and then
redo the copy process. This time only the sheet you paste the data into gets
it, not sheet 3.
--
Kevin Backmann


"O Wayne" wrote:

I am trying to copy data (value only) from shh1!a1 to sh2!a3. When I put
=sh1!a1 in sh2!a3 it also copies to sh1!a3. If I delete sh1!a3 it deletes
sheetsh2!a3. I would like changes in sh1!a1 to reflect in sh2!a3.
Thanks.

Copying data from sheet to sheet.
 

Do you have those sheets grouped, i.e. does it show [Group] in the
title bar? If so, right-click one of the sheet tabs and click on
Ungroup Sheets.

Hope this helps.

Pete

On Jan 15, 4:20*pm, O Wayne wrote:
I am trying to copy data (value only) from shh1!a1 to sh2!a3. When I put
=sh1!a1 in sh2!a3 it also copies to sh1!a3. If I delete sh1!a3 it deletes
sheetsh2!a3. I would like changes in sh1!a1 to reflect in sh2!a3.
Thanks.

Copying data from sheet to sheet.
 

Thanks, works great.

"Kevin B" wrote:

You have inadvertently selected sheets 2 and 3 and they're working as a
group. Right click on either Sheet 2 or Sheet 3 and Ungroup Sheets and then
redo the copy process. This time only the sheet you paste the data into gets
it, not sheet 3.
--
Kevin Backmann


"O Wayne" wrote:

I am trying to copy data (value only) from shh1!a1 to sh2!a3. When I put
=sh1!a1 in sh2!a3 it also copies to sh1!a3. If I delete sh1!a3 it deletes
sheetsh2!a3. I would like changes in sh1!a1 to reflect in sh2!a3.
Thanks.

Copying data from sheet to sheet.
 

It did help, Thanks.

"Pete_UK" wrote:

Do you have those sheets grouped, i.e. does it show [Group] in the
title bar? If so, right-click one of the sheet tabs and click on
Ungroup Sheets.

Hope this helps.

Pete

On Jan 15, 4:20 pm, O Wayne wrote:
I am trying to copy data (value only) from shh1!a1 to sh2!a3. When I put
=sh1!a1 in sh2!a3 it also copies to sh1!a3. If I delete sh1!a3 it deletes
sheetsh2!a3. I would like changes in sh1!a1 to reflect in sh2!a3.
Thanks.

Copying data from sheet to sheet.
 

You're welcome.

Pete

On Jan 16, 11:40*pm, O Wayne wrote:
It did help, Thanks.