Hi

I'm new to creating Macros but would be grateful if someone could tell me if it's possible to create a Macro for copying data from a cell and pasting it into certain part of another cell. The data in the cell to pasted to is exactly the same on each cell line. For example the title is in Cell A and i need to paste it into a certain part of Cell G. And repeat this process down to the bottom of the sheet.

I've tried but i keep getting an error message saying Unable to record when trying using excel.

One more thing the data in the cell to be pasted to is in HTML format, it starts with <br> does this matter ?

Thanks

Paul