I've written some VB that pulls a large set of data (pivot table friendly) from the server (nuking any data already in that sheet).

The users would now like a user friendly view of that data (in Excel) (some styling, fewer columns)...

Apart from lots more VB that copies ranges, adds styling etc I can't think of anything nice.

Any better suggestions?

Many thanks

Sam