Hi everyone,

I was wondering if someone can please help me with a VBA code to export worksheets from source workbook to a new workbook. Please see below specific points for what I have and what I need, apologies in advance if I this is not very clear.

What I have;
A source workbook with 6 worksheets named A, B, C, D, E and F
Few Rows are hidden & Data is filtered
There are extrernal links within the source workbook

What I need;
Export only visible cells from worksheet B, C and D into a new workbook
Retain the data into its seperate worksheets in the new workbook
Delete any external links in the new workbook
Copy & Paste Special Value data
Column Width and Row Height should stay as it is.
All the formats should stay as it is apart from any 'Fill Colour' which needs to be 'No Fill'

Thanks for your help