Hi Memphis,

When you "repeat this over and over later to select
many other cells that have to be copied to different sheets. . ."

1. Are you always using A1 from Datawrksht and C9 on Worksheet1
and B1 from Datawrksht and c10 in Worksheet2?

2. How do you know to repeat this several times?

3. What is the difference between 1 and 2 and
. . .many other cells that have to be copied to different
sheets.. .?


Dan