I have a Packing list on Sheet1,inventory Sheet2 and Customer info
Sheet3.
Sheet1 linked and formulated to pull data from sheet2 and sheet3. I
added save botton to save each packing list to another
folder(C:\Paking_List06) I would like to know how to write a VBA code
to export Sheet 1 to packing list folder.

Thanks