Copy Rows to New Sheet Based Off Of Checkbox Criteria

Think I'm way in over my head. Not even sure where to begin. Have a master list of all of our clients and their contact information. About 4500 entries and constantly changing/adding. I want to be able to create a new list on a new sheet based off of 2 areas of criteria selected by our users from a check box menu. Been trying to piece meal something together from my very limited knowledge of VBA but nothing is working.

'Master' List Sheet = Source
'02 Selection' New List Sheet = Target
'01 Criteria' Selection Sheet = Condition

Source information can be found between "BorderFirstRow" and "BorderLastRow" on the Master since the list length shortens and lengthens continuously.

Please Login or Register  to view this content.

The First Criteria list, which has Check Boxes and returns TRUE or FALSE in cells 'Condition'!I3:I21 while looking in Columns/Table of 'Source'!W:AS for a 'Y'
The Second Criteria list, which has Check Boxes and returns TRUE or FALSE in cells 'Condition'!I29:I264 while looking in Columns of 'Source'!B for a match to 'Condition'!C29:C264.

The end user makes their Group Selection and Scope of Work Selection based on project criteria. I would like to have a macro that then finds which Contacts in the Master sheet match the criteria and then copy the entire row over to the '02 Selection' sheet.

The numbers in Column B of the Master sheet for the CSI code are formated as text to show the 0 in front of them and keep the formatting consistent.

Copy of the sample file can be found at: send(dot)tresorit(dot)com/a#l0yM5hJ1NLJtS8cuWyB3Xw

Thank you for your help!

Hi,

We don't need to see illions of rows if that's the cause of the large file. Just delete the bulk of them and leave just sufficient to show your problem.

If that doesn't work then save the file as a .xlsb file and try uploading again.

Will you please attach a sample Excel workbook? Try copying the data to a new workbook.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Note: As a new member, you are not yet allowed to post links. That privilege will come once you have made at least ten posts.

How many lines of data did you copy? We only need a few.

link to file: removed by moderator

Please see attachment to post below.

Please don't ask us to jump through hoops and expect us to go to file hosting sites of unknown provenance.

Do as I suggested. Save it as a .xlsb file. The forum accepts these up to 9.4 Mb

I suggested this in a private message only because you were claiming not to be able to make your file small enough to post. As you have now managed this, I shall remove the pseudo-link to the file-sharing site.