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
Bookmarks