MACRO for Matching Data on New Tab

[richmcgill]

I have two spreadsheets below. One on the left and one on the right of the black bar.

The spreadsheets are comparing mismatching address data and the way they are doing it today is creating a formula which creates a Yes or No match result.

They then manually create a tab for all of the matching items / with a Yes.

So a tab for all of the Yes's for the F=L's, F=M's, etc..

Is there a way if there is a 'Yes" that all of the loans with a 'Yes" for that formula and all of the data on that row be moved to a new tab with that formula as the tab name?

Example - can the counts of the loans in each of the tab be added to the name?

 

[aRandomHelper]

Hi, a short answer is 'Yes', all you asked is reasonably doable.

But in order to reduce confusion and/or mistakes, it's best you provide the following details:
- What is the worksheet name on the right of black bar?
- What are all the columns in the worksheet above^?
- ^this question because your 'move-to' worksheet shows "F=O" but this isn't shown on the worksheet on the right of black bar -- are there hidden columns?
- What is the structure (columns) in your 'move-to' worksheets? Are they all the same, and same as the worksheet on the right of black bar?
- ^If not the same, what should/should not be moved?
- When moved, should they be removed from the worksheet on the right of black bar? Or simply copied over only?
- If possible, provide the list of all the 'move-to' worksheets.

 

[richmcgill]

 

[richmcgill]

Right now all is on one tab - worksheet
All of the open cells to the right of the loan number will have addresses and other data.
No hidden columns

Keep the same set of headers for all results and new tabs.
The new tab should use the title name of the field that has the "Yes" should be the tabs title.
If there is a "Yes" the same header should pull over with all of the rows of data from A though Y.
Examples
A "Yes" for F=L would include rows A2 through Y5.
A "Yes" for F=M would include rows A5 through Y9.