Copy Data from Range on Specific Worksheet and Transfer Data to New Workbook

VBA Experts,

I found this VBA code somewhere and tried implementing it in my workbook but am having trouble customizing it to my needs.
This code does a very good job at copying everything on a specific worksheet and transferring it to a new workbook. However, what I can't figure out is how to get the code to copy data from A6 until it finds the last row with data in column E. I have specific formatting i.e. borders and colors which I would like to keep but would like the actual data to be values only (no formulas). Can someone please help me with this?

Thank you so much in advance.

J

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Hi John,

Thank you for your help and quick reply. I ran your code but it is still copying everything above A6 as well. Is there a way to copy everything below A6?

Thank you again!

J

Best too test this on a copy first:

Please Login or Register  to view this content.

Hey John,

The clear contents didn't quite work but it lead me to an alternative solution which was to just delete rows 1 - 5 in the new workbook. I'm going to mark this as solved.

Thank you again for your help!

J

Please Login or Register  to view this content.

You're welcome. Glad to help out and thanks for the feedback.