linking cells to other sheets within a workbook
 

I'm trying to link/copy specific rows of data to other specific sheets within
a workbook. For example, in the main sheet, data cells entered on row 16
would be copied to the first unused row of the sheet specified by contants
of row a16. Then, contents of row 17 would be transferred to first
open/unused row of sheet specified by contents of cell A17. Rows transferred
may /or not be to the same sheet with each transfer/copy. Can anyone help
with this?

linking cells to other sheets within a workbook
 

To copy cells from one sheet to first unused row in another sheet you need
VBA code.

See Ron de Bruin's Copy/Paste/Merge examples.

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

Maybe specifically this page.

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


Gord Dibben MS Excel MVP

On Wed, 11 Feb 2009 09:47:18 -0800, SPL
wrote:

I'm trying to link/copy specific rows of data to other specific sheets within
a workbook. For example, in the main sheet, data cells entered on row 16
would be copied to the first unused row of the sheet specified by contants
of row a16. Then, contents of row 17 would be transferred to first
open/unused row of sheet specified by contents of cell A17. Rows transferred
may /or not be to the same sheet with each transfer/copy. Can anyone help
with this?