VBA to combine cells if value is the same

B

BradStoran

New Member
Joined
Mar 9, 2016
Messages
2
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:confused::confused::confused:

[TABLE="width: 1573"]
<tbody>[TR]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Name[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Synopsis[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Description[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Host[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Port[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Risk[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Protocol[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"]Solution[/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"][/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"][/TD]
[TD="class: xl66, width: 143, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=002060]#002060[/URL] , align: center"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1144"]
<tbody>[TR]
[TD="class: xl63, width: 143, align: center"]Windows Terminal Services Enabled[/TD]
[TD="class: xl63, width: 143, align: center"]The remote service advertises one or more protocols as being supported
over TLS.[/TD]
[TD="class: xl63, width: 143, align: center"]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.[/TD]
[TD="class: xl63, width: 143, align: center"]192.168.34.5[/TD]
[TD="class: xl63, width: 143, align: center"]443[/TD]
[TD="class: xl64, width: 143, align: center"]None[/TD]
[TD="class: xl63, width: 143, align: center"]tcp[/TD]
[TD="class: xl63, width: 143, align: center"]n/a[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 143, align: center"]Windows Terminal Services Enabled[/TD]
[TD="class: xl63, width: 143, align: center"]The remote service encrypts communications.[/TD]
[TD="class: xl63, width: 143, align: center"]This plugin detects which SSL and TLS versions are supported by the
remote service for encrypting communications.[/TD]
[TD="class: xl63, width: 143, align: center"]192.168.34.5[/TD]
[TD="class: xl63, width: 143, align: center"]443[/TD]
[TD="class: xl64, width: 143, align: center"]None[/TD]
[TD="class: xl63, width: 143, align: center"]tcp[/TD]
[TD="class: xl63, width: 143, align: center"]n/a[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 143, align: center"]Windows Terminal Services Enabled[/TD]
[TD="class: xl63, width: 143, align: center"]The remote service encrypts communications.[/TD]
[TD="class: xl63, width: 143, align: center"]This plugin detects which SSL and TLS versions are supported by the
remote service for encrypting communications.[/TD]
[TD="class: xl63, width: 143, align: center"]192.168.34.5[/TD]
[TD="class: xl63, width: 143, align: center"]3389[/TD]
[TD="class: xl64, width: 143, align: center"]None[/TD]
[TD="class: xl63, width: 143, align: center"]tcp[/TD]
[TD="class: xl63, width: 143, align: center"]n/a[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You must log in or register to reply here.

Similar threads

N
  • Question Question
Join data from second worksheet with delimited list values (mults) to another worksheet with one value per cell/row and keep 1:1 relationship
Replies
2
Views
1K
HeadAgainstABrickWall
H

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top