hi all,

does anybody have an idea of how to create a macro that will automatically create a pivot table from data in another worksheet?

Tried but the macro always halts and its griving me nuts!