Adding additional selection criteria to existing Macro

Good Morning,

The attached macro has been very kindly modified by a forum representative to copy rows from the "Master sheet" to "Sheet2" when any cell in "Column B" of the "Master Sheet" is "like" a variable placed in cell G2 of the "Master Sheet" by the user. This Macro does the job extremely well but I would very much appreciate help in adding just one more selection criteria to the existing. I have made several attempts at adding the "and" function to the routine but to no avail. My knowledge of Macros can be written on a postage stamp.

Column "A" of the "Master Sheet" has a six digit numeric sequence starting at 10773 and currently ending at 20186 but this will increase as rows are added. I would like to also include column "A" within the existing selection criteria to only copy rows to "sheet2" if the cells within column "A" are between two values placed in say J2 and K2 of the master sheet. e.g. 10805 and 10926.

Hope I have explained this correctly.

Your help will be most appreciated

Take care


Trevor

Please Login or Register  to view this content.

Good afternoon, my request for help didn't get a response but I have managed to find a solution by reading up on the subject.

Many thanks

Trevor