Hello everyone!
Im new to VBA, wondering whether what im trying is possible. Forgive me if this is elsewhere but I've searched for several hours with no luck.
What I'd like to do is this:I want to sort data in generic and Mandatory & Differentiating sheets and sorting is based on "Y" present in boath sheet and want sort data in output sheet with yellow colour.
Please find the attached sample file.
Regards,
upa
Hi UPA - this would be less fiddly if the two sheets had the same format. Either three sheet all with the same format as "generic" or all three amenity types in the one sheet. Is either viable?
MatrixMan.
--------------------------------------
If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.
Hi UPA - this would be less fiddly if the two sheets had the same format. Either three sheet all with the same format as "generic" or all three amenity types in the one sheet. Is either viable?
Also - are all the yellow cells to appear at the top of each column as you've shown or alphabetically with the rest? Or do you mean alphabetically within the yellow cells then alphabetically within the non-yellow cells? The example output doesn't seem to match the description ... can you clarify?
Hi UPA. I standardised the data and split the "Mandatory & Differentitating" sheet into two sheets in the same format as the Generic sheet. Code is below and working version in the attached file. Let me know what you think.
Please Login or Register to view this content.
Hi MatrixMan, thanks so much for all your hard work and efforts in producing this VBA code - it's amazing and it works very well.
I have made little change in code
Call MatchAndSort(ThisWorkbook.Worksheets.Item(2), "Differentiating")
To
Call MatchAndSort(ThisWorkbook.Worksheets.Item(3), "Differentiating")
Now its working fine.
Regards,
upa
Ah yes - I neglected to change that when I created the 3rd sheet! Glad it's working for youDon't forget to mark solved & Add Rep if you're happy.
Cheers, MM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks