| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER
WHEN I COPY DATA FROM A SPECIFIC CELL IN WORKBOOK "A" TO A SPECIFIC CELL IN
WORKBOOK "B" THE COMMENTS SRE NOT TRANSFERED. HOW DO I FIX THIS? HELP PLEASE!!!!!!!!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHER
Firstly, please don't SHOUT. [Get your caps lock key repaired.]
Secondly, Edit/ Paste Special/ Comments will paste comments specifically, but for me (with Excel 2003) if I copy a cell and paste it into another workbook it pastes the comment too, so I don't know why you're having the problem. -- David Biddulph "BGA" wrote in message ... WHEN I COPY DATA FROM A SPECIFIC CELL IN WORKBOOK "A" TO A SPECIFIC CELL IN WORKBOOK "B" THE COMMENTS SRE NOT TRANSFERED. HOW DO I FIX THIS? HELP PLEASE!!!!!!!!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHE
Thanks for your reply, caps lock now fixed! Unfortunately I am not using the cut and paste method as the formulas in workbook "B" are set to read the value of a cell in workbook "A" but still only retrieves the data and not the comments. Any ideas? "David Biddulph" wrote: Firstly, please don't SHOUT. [Get your caps lock key repaired.] Secondly, Edit/ Paste Special/ Comments will paste comments specifically, but for me (with Excel 2003) if I copy a cell and paste it into another workbook it pastes the comment too, so I don't know why you're having the problem. -- David Biddulph "BGA" wrote in message ... WHEN I COPY DATA FROM A SPECIFIC CELL IN WORKBOOK "A" TO A SPECIFIC CELL IN WORKBOOK "B" THE COMMENTS SRE NOT TRANSFERED. HOW DO I FIX THIS? HELP PLEASE!!!!!!!!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I COPY ALL DATA (INC COMMENTS)FROM 1 WORKBOOK TO ANOTHE
So you're not copying as your original post stated.
Linked target cells will only return the values from source cells. Comments and formatting are not linked. Gord Dibben MS Excel MVP On Wed, 10 Oct 2007 19:11:00 -0700, BGA wrote: Thanks for your reply, caps lock now fixed! Unfortunately I am not using the cut and paste method as the formulas in workbook "B" are set to read the value of a cell in workbook "A" but still only retrieves the data and not the comments. Any ideas? "David Biddulph" wrote: Firstly, please don't SHOUT. [Get your caps lock key repaired.] Secondly, Edit/ Paste Special/ Comments will paste comments specifically, but for me (with Excel 2003) if I copy a cell and paste it into another workbook it pastes the comment too, so I don't know why you're having the problem. -- David Biddulph "BGA" wrote in message ... WHEN I COPY DATA FROM A SPECIFIC CELL IN WORKBOOK "A" TO A SPECIFIC CELL IN WORKBOOK "B" THE COMMENTS SRE NOT TRANSFERED. HOW DO I FIX THIS? HELP PLEASE!!!!!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why wont my comments copy from 1 workbook to another?? | Excel Discussion (Misc queries) | |||
| Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| copy excel workbook to new workbook without data | Excel Worksheet Functions | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
Linear Mode
