No experience, special copy and paste column macro

Hi,

I have zero experience in VBA macro. There's a worksheet that I'm working on that requires many steps and I was wondering if it's possible to combine it into a single macro.

1. Copy and paste column B through G starting starting at row 2 and paste into a new worksheet in a single column.
2. After the data is in a new worksheet, I would also like for it Sort that column from A through Z
3. Then insert a new row to give a column a header name called "Description"
4. Then do a subtotal count function on that column

I'm not sure if it's possible but any help would be appreciated. I've included the excel sheet and thank you so much in advance!

Its possible...anythings possible with VBA


Can you just confirm step 1, what do you mean by paste into a single column?

are you saying that if in columns B to G you have (I've shown columns seperated by
A;BC;1;EFG;H;AAAAA;

you want it to take that, concatenate the values and output "ABC1EFGHAAAAA" into a cell on the new worksheet?

Like I want to copy all the data from column B through column G and paste it all in a single column under column A on a new sheet. I know you can manually do it by using the paste all function from the clipboard. You can copy all the columns you want and then use clipboard to do a paste all and it'll paste everything you have copied onto the clipboard.

what i've been doing is manually copy and paste all the columns i want into a single column.
then i select the single column sort it from a through z.
then I insert a heading for the column called Description
Then I use the subtotal command, function is count....then it does the count for me

I've attached another excel sheet to show what the result is suppose to be.

Sorry for all the confusion. I'm pretty bad with explaining things lol

The 1st thing Id ask from your results is, do you really need all the data in that second sheet or will the subtotals themselves do? The reason I ask is when you expand the Pivot, theres no additional data there just a list (sometimes in the thousands) of the same value (take C01 as an example). Do you really need to be able to expand that or would the list of totals give you what you need?

I basically just need the total count for each value from column B through G with the exception of row 1 cause it's just a header row....the reason it's all there because it's the only way I know how to count them using the subtotal function

thank you for the quick response. When I hit run...The result didn't come out right =/

Oh no I see it now. It's doing what it's suppose to...just it's doing it for all the columns instead of just from B through G only. How do i adjust it so it's only doing column B through G only? and thank you so much for the quick reply

wow........thank you so much for your help! I didn't think this was possible....seriously....you just saved me a TON of time from this repetitive task.