LinkBack URL
About LinkBacks
Lacaycer 
Hi Lacaycer
Please wrap your code in Code Tags.
Have you considered using AutoFilter for this exercise?
Hi Lacaycer
Please wrap your code in Code Tags.
Have you considered using AutoFilter for this exercise?
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Example.xlsx
I tried entering the macro and was unable to make it work more than once. It was either returning the range global error, or pasting the column title. So I figured if you could see what I was trying to do or how it is actually applied, as well as explaining what I'm trying to achieve I might have better luck in solving this problem
Hi Lacaycer
Far as I can tell the code in the attached does this:
- Copy the names in $Q$2:$Q$49 that are not present in $F$2:$F$49
- Past names into the next empty cells in Column "F"
- Also transpose names into next empty cells in row of "Master Matrix" sheet
- But if there are no names that are different between "Q" and "F"….Do nothing.
It does not do this as yet:
- then sort both named ranges "StatusList" & "MasterList"
Are we on track with what we have?
It works, I'm sure that's no surprise to you. Thanks alot. I probably could have spent another 8 hours just trying to figure this out.
Hi Lacaycer
You're welcome.
Will you be doing the Sort Code? If not please explain how you wish each Named Range ("StatusList" & "MasterList") sorted.
I was going to attempt to record a macro of me sorting the two ranges alphabetically and then trying to figure out how to apply them to the macro you wrote. But if it's not any trouble, your help would be much appreciated.
Also does it matter at all if the button that runs the Macro is located on another worksheet. In the full file it will actually be located in a tab called "DynamicMatrix"
"MasterList" is sorted in row 3 (Left to right)
"StatusList" is sorted in Column "F"
Hi Lacaycer
Sort routines have been added...check them out carefully...they seem to be working as desired but you've got a lot going on. Only you know what YOU want to happen.
Please note:The code performs as I expect. Let me know of issues.
- I've added a Header in Cell F1 of ManpowerHelper
- I've changed the Named Range StatusList to include this Header
- I've moved the Button to Master Matrix Sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks