how to split the same sheet for different companies

[danielpak]

Hi, I have one excel recording every company's sales and shipments.
Some of the prices are linked to the data in "LME" sheet supposingly but I only copied the numbers into the file I attached here so no formula showing in this file.

I need to send this excel to each customer with their own records.
I tried to create a pivot but there are merged cells so didn't work well.

Is there a way to copy all rows where a certain customer is showing, together with all formulas and formats and the whole sheet of "LME" to a new excel, saved at PC's "documents" folder, naming the file as "company name - Shipping Record", say, "XYZ - Shipping Record"?

Now what I am doing is to copy all data to a new excel, delete all other customers and save it to "documents" folder manually.
This is quite troublesome cos there are more than a thousand rows in my original file.

I am wondering if VBA can do it easily?
Thanks a lot!

Daniel