Linda Barwick
New Member
- Joined
- Sep 16, 2002
- Messages
- 2
this may be a really dumb question, forgive me!
I have an excel file containing genealogy data. I've been trying to record a macro to copy the contents of every second line in one column to the adjacent right column.
I just can't seem to get it to work.
What I would ideally like to do is to select every second cell in the column, then cut and then paste them to the right. But excel tells me it can't cut this type of selection.
Any suggestions?
Thanks
Linda in Sydney
I have an excel file containing genealogy data. I've been trying to record a macro to copy the contents of every second line in one column to the adjacent right column.
I just can't seem to get it to work.
What I would ideally like to do is to select every second cell in the column, then cut and then paste them to the right. But excel tells me it can't cut this type of selection.
Any suggestions?
Thanks
Linda in Sydney