List Unique Suppliers in Summary

**Richard Buttrey** · 05-05-2015, 11:00 AM

Hi,

That's a slightly different requirement to your original request. I'm interpreting this to mean that you are automating with a looping procedure the import, process & saving of the file rather than doing this once as originally implied.

Notwithstanding that I'm not clear why you think a PT is too time consuming. Refreshing a PT will be much quicker than any macro process to filter and summarise.

Why not create a dynamic range name for the import area of your data and build a PT that uses that range name and just have an additional single line of code in your import macro code to refresh the PT before the Save part of your macro.

**ChrisMattock** · 05-05-2015, 11:08 AM

Originally Posted by Richard Buttrey

Hi,

That's a slightly different requirement to your original request. I'm interpreting this to mean that you are automating with a looping procedure the import, process & saving of the file rather than doing this once as originally implied.

Notwithstanding that I'm not clear why you think a PT is too time consuming. Refreshing a PT will be much quicker than any macro process to filter and summarise.

Why not create a dynamic range name for the import area of your data and build a PT that uses that range name and just have an additional single line of code in your import macro code to refresh the PT before the Save part of your macro.

Hi Richard, sorry I wasn't clear, I just wanted help with one small aspect of the project so I didn't detail the entirety. Apologies for any confusion, I'll have a look into your suggestion - but I haven't used dynamic range names before... nor have I used PTs from macros before. Hence I was going for the solution where I understand at least 90% of the solution.

Thanks for the help.