Deleting rows after copying data
Mark,
I'll check into that. Thanks for the quick response!
"mark" wrote:
You could do that by using variables to track what the new
value is, as compared to the old value, etc. and then
adding the contents, as you say.
But, what you describe is exactly what Data-Consolidate
does.
Maybe take a look at that from the Data menu... see if it
does what you need. Data-Consolidate can be programmed as
well.
-----Original Message-----
Greetings!
Using Excel2002 - I am a beginner when it comes to
programming.
Here is my challenge: I have a worksheet that contains
data in which I need
to be able to perform the following.
I need to be able to check the ID numbers in column A,
and determine if it
is the same ID number from the previous row. If the ID
number matches, then
I need to copy data from the second row and add it to the
end of the first
row and then delete the second row. This needs to
continue to the end of the
data -- currently about 12000 rows. Some IDs will have
two records and
others will have up to 15 entries.
.
|