Hi,

I need to copy a row such as A2:X2 from 1 workbook to another but I need it to Paste LINK in the next available row. What is the VBA code for this? I'm a beginnger at this programming stuff...

While I'm here asking questions, is there anyway to record a macro then let it run across multiple sheets? Lets say I need it to edit a web query link then make that link change in the same cell across many sheets in a work book, how do I do that?

Please help! Thanks!