Copying rows from one Excel spreadsheet to another

G

Guest

At my office, we use Excel 2000 (9.0.3821 SR-1). I have a daily spreadsheet
that I maintain and add comments to one of the cells. At the end of the week,
I maintain a weekly spreadsheet in which I copy the rows in which I have
comments to the weekly spreadsheet. Sometimes, it allows me to also copy the
comments, and at other times, it does not, and then I have to re-add them.
Can you come up with a reason and a solution?
 
G

Guest

What do you mean by "allows me"?
If you do a regular copy as in ctrl + C it will copy everything,
if you only want to copy comments, copy and when pasting do edit>paste special
and select comments.

that will work with excel 2000

Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How DO I Increase The Excel Cell Comment Data Capacity? 1
Merging the Changes from One Excel Document into another 9
copying just the macro from one spreadsheet to another 1
Linking 2 spreadsheet using data from the last row of spreadsheet 13
Lookups - how to obtain data from a master spreadsheet into another 5
Copy and pasting values of filtered rows 1
How do I print an Excel worksheet to include the comments? 1
Appending Data from one spreadsheet to another 4

Top