linking data between sheets
 

I'm trying to link/copy specific rows of data to specific sheets from a main
worksheet. For example, row 16 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A16 of the main
sheet. Contents of row 17 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A17 of the main
sheet. Can you suggest a method to do this?

linking data between sheets
 

Hi,

If you mean copy, then there is no function to do this automatically, you
will need to write a VBA program. If you mean link then you might create a
rather complex formula to do it. But you need to decide exactly what you
want and you need to tell us how the program should decide what sheet to copy
or link to. What is in A17 that clues us in?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"SPL" wrote:

I'm trying to link/copy specific rows of data to specific sheets from a main
worksheet. For example, row 16 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A16 of the main
sheet. Contents of row 17 of the main sheet would be copied to the first
unused row of the sheet specified by the contents of cell A17 of the main
sheet. Can you suggest a method to do this?