Seems like I have seen this question posted before. If you didn't get a
response, it generally means that the question isn't understood (or less
likely, it is not doable or to complex to attempt an answer (someone wants a
free project done for them)).

I would guess your question is not understood. For me:

So the question you ask is:

I just need the VBA code that will do the parsing of these values

What do you mean by "these values"? What do you mean by parsing?

--
Regards,
Tom Ogilvy


"klysell" wrote:

Hi,

I have two adjacent columns, occuping Column C and D (range C15:D100), in my
summary sheet. The user selects values from a drop-down list in both columns,
with one OR the other value in a pair being selected (and the other remaining
blank).

I would like to dynamically generate pivot tables based on data from my
"PivotData" sheet, according to a pre-arranged PT format, with either the
value in Column C OR Column D forming the Pivot table page filter.
Essentially I'd like a macro to create new worksheets, each with a new pivot
table using a page filter from one or the other value of user-chosen,
drop-down values in Column C or D.

Perhaps once the user has selected values in Column C and D (e.g. for row
15, either C15 or D15 is filled with data using a data validation function),
a macro will parse these values in separate worksheets and a pivot table is
generated using this values in Columns C and D as page filters.

I already have a pivot table designed, and I know that I could turn on the
macro recorder and use this code when dynamically generating all the pivot
tables. I could then refine this recorded macro to be more efficient (i.e.
using knowledge gained from John Walkenbach's Power Programming with VBA
book). I just need the VBA code that will do the parsing of these values.

What would be my best route to solve this problem?

Thanks in advance,
--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.948-9557