Automatically copying cells to another workbook

[Just Askin]

Is it possible to direct Excel to look at the value of a cell in a row and
then copy a set of cells (like all the cells in that row) to another
workbook? And to execute this for each row in a worksheet?

 

[Gord Dibben]

Have a look at Ron de Bruin's Copy/Paste/Merge VBA code examples.

http://www.rondebruin.nl/tips.htm


Gord Dibben MS Excel MVP