I can't and won't argue with that logic. I don't have much of a
choice, though, since it's both not my database and not my pivot
table. I'm simply trying to find an easy solution to take a time
consuming and error prone step or two out of the process.

So that said, any thoughts on how I might go about at least doing an
index/match where the indexed array is dynamic as well as the matched
array (which is in a row vice a column)?

Thanks!!

Frank

On Fri, 28 Apr 2017 14:50:50 -0400, GS wrote:

To be perfectly honest.., I never use pivot tables! I tend to handle data in
the way a database app would, where I use a userform with a data grid and
controls that allow users to do criteria based queries on the underlying
'recordset'.

Pivot tables only work in spreadsheet apps that support them. Database queries
work everywhere! This allows me to reuse the same code in VB6 apps as well. I
see pivot tables as a user friendly alternative to viewing data by changing
criteria in the table. Nice for spreadsheet users not versed in db programming!
(just saying...)