| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying data from sheet to sheet.
You're welcome.
Pete On Jan 16, 11:40*pm, O Wayne wrote: It did help, Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Copying Data from one sheet to another sheet on a specific day | Excel Worksheet Functions | |||
| Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Linear Mode
