I'm not a VBA code writer at all (trying to learn) but I feel like I need VBA to do what I need.
I have an "Applicants" sheet where all my information is kept.
In columns G:T there is a cell to type "Yes" in, if that applicant wants that type of Apartment.
I have other sheets dedicated to the apartment types so I can print them out for whatever reason.
"Efficiency" is next tab. I want to populate the next available rows in columns B:F from corresponding cells from the "Applicants" sheet, keeping them in a definite order. based on the "YES" entries.
I have a basic formula on the "efficiency" page, and I could enter everything with that, go to special and delete the blanks in my "Efficiency" page once all my entries are put in, but I was trying to see if there was another way..
File attached...