Debra,

By "marking" data lines, I was referring to the possibility of "marking"
data lines in the individual analysis pivot table spreadsheets generated
when you do a "show pages" from the original pivot table. For example,
from the main pivot table I have generated more than a hundred pivot
table analysis spreadsheets for different countries (each spreadsheet
page shows one country's data).

As all the analysis has been done in these individual spreadsheet pages
generated by the "show pages", is there a way to "mark" or identify
specific lines of data in each of the spreadsheets and be able extract
these lines from the whole set of spreadsheets in one shot. Ultimately,
I would like to be able to use this info to extract the original data
lines from the original source data used to make the pivot table in the
first place?

I hope I've been able to explain it clearly. How do you think would be
the best way to do this?

Thanks again, and looking forward to your suggestions.

Best regards,

Anne Nasser



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!