Excel help please

[surf]

I am by no means a whizz at macros so would be grateful for some advice please?

 

I am creating an audit spreadsheet where scores are attributed to various questions and space is available in the next cell to enter a comment if necessary.

 

As we are running to several hundred questions I would like to transfer any comments to another worksheet so they are grouped together instead of appearing with gaps under them.

 

Can anyone suggest a relatively easy way of doing this please?

 

many thanks

 

Can't you just copy the column to a new worksheet and then sort it? That way all the comments are in the top cells.

[Montse]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[surf]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited June 13, 2006 by surf

[ChrisC]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Montse]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Montse]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here