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:
Thanks
Bookmarks