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!!!!!!!!!!!

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!!!!!!!!!!!

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!!!!!!!!!!!

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!!!!!!!!!!!