Hi there,

I currently have this code whereby it extracts a worksheet and saves into a new workbook.

I am trying to make it extract from row 5 and below.

From columns O-U are locations as follows:

Column O: Marston Green
Column P: Test Engineering
Column Q: West Hartford
Column R: Singapore
Column S: Xiamen
Column T: Neuss
Column U:Dubai

I have a userform interface with checkboxes.

I want the code to program so if you select a checkbox it extracts the specific columns according to that checkbox. You can see the columns I want to be extracted:

Marston Green: B:O
Test Engineering: B:N,P:P
West Hartford: B:N,Q:Q
Singapore: B:B,R:R
Xiamen: B:B,S:S
Neuss: B:B,T:T
Dubai: B:N,U:U

Also if its possible to extract two checkboxes at once. Because I try to do this and it says 'cannot changed part of merged cell.' Also when I run the code the 'save as filename' doesn't work.

Here is the code I currently have:

Please Login or Register  to view this content.

Thanks