VBA Code shouldn't export header information

[Magerator]

Hello,

I got awesome code from your site , but would need still a little assistance with it.
The code below works great. It exports pivot details to new sheet with timestamps and all that. But there is two things I would need still :

1) I would like that headers wouldn't be exported at all.
2) I created a drop down box for different waste codes on the sheet "TOY Mill Stocks".
That information should be copied to waste_proposals.xls next to the time stamp.

EDIT : The waste code that is selected from the combo box, is fetched with index-formula to cell K13...if this information is needed.

Hopefully you can help me.

Code here :

Please Login or Register  to view this content.

- Jyri

[davesexcel]

This code will select A2 to the last used range in a cell.
So if row 1 is your headings, it won't get copied

Please Login or Register  to view this content.