Copy row data

[gmoorthy]

I have a huge excel spreadsheet

Number description code date
1234 Test1 A 12/31/1998
1234 Test2 B 04/13/2020
7890 Test3 C 05/06/1999
4567 Test4 D 01/03/1999
4567 Test5 E 09/03/2020
4567 Test6 F 06/07/2020


What I want is that if the two numbers are same then description, code and date should be copied over to the first number

So it be
1234 Test1 A 12/31/1998 Test2 B 04/13/2020

 

[gmoorthy]

I changed the int no Val to string and it worked.

If I have more columns what I need to do copy them ?

Thanks a lot Andy and Skip

 

[gmoorthy]

Figured that out in the code determines the columns.

 

[Andrzejek]

I see you wanted to cram something other than a number to [tt]intNoVal[/tt] variable (from column A) which would only accept a number. So, if you tried to assign a text value to it, you got error 13 type mismatch :-(

And yes, " in the code determines the [last] column" co be copied.


---- Andy

There is a great need for a sarcasm font.