Hi all,
Hope someone can help?
How can I asign a macro to a hyperlink or cell in column D, which copies the data from cells in the same row in columns A,B & C, then pastes to Sheet2 & inserts a new row ready for next pasted row above? I can record the basic macro, but struggle to assign it to a cell or hyperlink which I can then copy down over 2500 rows, each of which would perform the same "copy,paste to Sheet2, then insert row" function on its respective row??

Appreciate any help.

Thanks
AJT