Pivot Table Using Multiple Named Ranges

Hi all,

Simple question.

How do you create a Pivot Table using multiple named ranges?

The ranges in this case will be "Time", "Date" and "Terminal"

Not sure what formula to input when creating the table to add all three ranges in

Thanks!

I have managed to figure out a quick work around for this just as you posted your reply. Thanks though