Parse specific sheet and specific column

[Webbers]

I need some help in modifying this macro, it works great but for my needs I just need some minor adjustments. The VBA code is also within my sample file, and connected to the macro button on the main tab, this is the format required for my end users.

1. The the macro is associated with active sheet currently, I need to have that changed to Sheet "Cross-Functional".
2. I want to remove the Input Box (for the column) and replace it with the column. Column: C "Service Line"
3. I would also like the sheet named "Cross-Functional" to unfilter the auto-filter (Column C) as it shows only Team 6 data once complete

Please Login or Register  to view this content.

[Joske920]

hi,

Please Login or Register  to view this content.

[Webbers]

Joske920,

I thought I was clear in what I was asking, I even went back and looked, and it was clear to me. I am sorry if there was any confusion. Your solution solved my issue, thank you very much, I greatly appreciate it!

[Webbers]

Joske920,

I didn't notice until I looked more carefully, but this macro is causing the new sheets (based on Column C, "Team") to go all the way to column XFD. I mean, there is no content in all those extra columns, but it appears to be part of the used range or something. There must be some way to designate the number of columns to prevent this from happening. For example, in this sample file, the data on "Cross-Functional" is A-D, 4 columns. Would you be so kind to take another look. The attached file, "Book2.xlsm", and in Module2, I added the revised VBA code that you provided.

[Joske920]

The .EntireRow.Copy makes this happen

selecting more then 1 column in the copy make it copy the whole table

it does not impact the excel

if you want that solved anyway
there will be a whole rewrite be needed

[Webbers]

Thanks for explaining it. In my head it should (should being the key word) be an easy fix to only copy the relevant data (4 columns). But as we both know, this just proves it doesn't always work that way. I appreciate your time, tysvm!