VBA code to separate & count matching items in a list

zakynthos

Board Regular
Joined
Mar 28, 2011
Messages
169
Hi,

Assuming I have an open-ended no, of names sorted into groups in Column A (starting A1)
What would be the VBA to:
Search and cut all names after group 1 (say, A1:A30),
Paste this new list - group 2 (say A31:500) into Column B (start B1)
Search and cut all names after Group 2 (say B50:B500)
Paste this new list into Column C (start C1) etc etc.
Repeat process into and paste to Cols D, E, F etc etc
Finally search the first blank cell in Cols A: etc
Provide a count of the number of items in each column

Thanks for your help.

 
Thanks so much - I don't know why I didn't think of the obvious - probably doing so much work recently that can only be done with VBA that I completely overlooked the obvious!

Once again, thank you very much for your help in sorting this with a simple solution!
:laugh:
 
Upvote 0

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Thanks so much - I don't know why I didn't think of the obvious - probably doing so much work recently that can only be done with VBA that I completely overlooked the obvious!

Once again, thank you very much for your help in sorting this with a simple solution!:laugh:

Your welcome and thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,722
Members
452,939
Latest member
WCrawford

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