LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Deleting rows after copying data

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting 63,886 Blank Rows Under My Data Kajuliano Excel Discussion (Misc queries) 15 January 19th 09 08:50 PM
Deleting Rows of Data SU Excel Discussion (Misc queries) 3 August 4th 08 08:32 PM
Copying data to excel and deleting duplicates Dom Excel Discussion (Misc queries) 2 January 3rd 08 10:25 AM
Deleting rows containing common data gcotterl Excel Discussion (Misc queries) 1 January 4th 05 12:58 AM
Deleting rows using key data shylu Excel Programming 1 September 13th 04 11:37 AM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"