Ok, here it is.
I merged data from ACCES and dropped it into Dataworksheet, each row goes
from A1 trough CB1
So, I need to select cells within this row and paste them onto different
worksheets that need to capture information such as name, bank account,
address, payment amount, etc.. So each worksheet is for a different
information category which needs to be extracted from row1 in Dataworksheet.
Basically, this is to show the current information we have about the case.

Each row in Dataworksheet is info for a different case.

Then I need to create a file after I paste the info from Dataworksheet.

Yes the receiving cells in worksheet1 are scattered, they are not like
a1:c1, name goes in A1, SSN goes in B2, etc...

NOw, to save code, I would like to delete row A1 from Dataworksheet, thus
bumping row A2 and next time I run the code, this will refer to row A1 again,
but this row will obviously have info about another case.

A bit winded, but I hope you get the idea as to what I need to do.

Thank you




"dan dungan" wrote:

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