Copy and paste comment on the adjacent cells

Hi all gentlemen.

A sheet, compose of groups of 9 items and their corresponding qty.
I need to have the same serial no. be commented on each items of the same group.
I am doing in this mechanical way:
1. add comment of serial no. on the first item of group,
2. copy and paste, with paste special>>comments, on the remaining items of the same group,
3. Repeat this sequences on the other groups, which means hundreds.

Other than these tedious procedures, is there any better way?

Many thanks

Originally Posted by Pauleyb

The 'paste comments' method is probably the fastest manual method. I question why you need these in comments. I would highly recommend you create a separate column with the serial numbers. I understand it is an extra column, but if the serial numbers are that important that they need to be with each cell, then why not just have it as a new column B? It certainly would make your data entry easier. Also, you could hide the column if it is really distracting, yet you could see the data by using the arrow keys to enter the cell while it is hidden.
The other alternative is to use a macro. If the serial numbers are sequential, as your example shows, then that could save you a lot of time. If they do not follow a pattern, then the macro would need to know the value for each group; either by reading the comment from the first cell of each group or referencing another cell or group of cells.

Thanks for your kindly reply.
If there is no better solution, your suggestion is also a way to go.
I have great interest in the macro. I guess it is not too complicated in writing a short macro to achieve the job. However I am innocent abut VBA. Can there be any further help on the writing of macro. The serial number is in sequential.
Many thanks

As you two have the same point of view, I suppose that would be the best solution.
Thanks for you both

Originally Posted by Pauleyb

Here is a quick and dirty macro that works with your sample sheet. note that your sample shows blocks of 10, not blocks of 9. This was written for blocks of 10. If you do not know how to add macros, then search the web for detailed methods.

Please Login or Register  to view this content.

Many thanks