Hi all,
Hope someone can help?
I have over 2500 rows of data in 8 columns (A10:H2500) and need to create hyperlinked macros on each row (in column I) which once pressed/activated copies the cell data in the respective row from column B and pastes into another sheet, then insert row ready for next selection (I can then do vlookups to draw in other respective data columns).
Anyone any ideas how to; (1) create the correct macro code to copy cell in column B in the same row of the selection, and (2) assign this undefined row selection based macro to a hyperlink which can be copied down 2500 rows!?? (similar I suppose to having a select button on a menu which then creates a bill on a seperate sheet!)

Appreciate any help.

Thanks
AJT