VBA to combine cells if value is the same

[BradStoran]

Hi,

Need help my codes keeps crashing my excel.
I'm looking to check is the data in cell A and Cell B is the same as Cell A and Cell B on row 2 for the entirety of the data on the sheet. e.g. if a2 row1 = a2 row2 and b2 row1 = b2 row2 Then combine D1 row 2 with d1 Row1 and E1 row 2 and E1 row1
then delete the rows that data has been copied from.

Any help would be appreciated.

Thanks,

Brad

Name

Synopsis

Description

Host

Port

Risk

Protocol

Solution

<tbody>
</tbody>

Windows Terminal Services Enabled	The remote service advertises one or more protocols as being supported over TLS.	This script detects which protocols are advertised by the remote service to be encapsulated by TLS connections. Note that Nessus did not attempt to negotiate TLS sessions with the protocols shown. The remote service may be falsely advertising these protocols and / or failing to advertise other supported protocols.	192.168.34.5	443	None	tcp	n/a
Windows Terminal Services Enabled	The remote service encrypts communications.	This plugin detects which SSL and TLS versions are supported by the remote service for encrypting communications.	192.168.34.5	443	None	tcp	n/a
Windows Terminal Services Enabled	The remote service encrypts communications.	This plugin detects which SSL and TLS versions are supported by the remote service for encrypting communications.	192.168.34.5	3389	None	tcp	n/a

<tbody>
</tbody>