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!
Bookmarks