richardvanderknaap
New Member
- Joined
- Jul 2, 2008
- Messages
- 2
Hello
I have a worksheet with a few thousand rows and about 25 columns arrive each week
The pivot on this data is really useful for me to interpret the data
when i wish to look at the underlying rows for a particularly value in the pivot by clicking on the value it opens a new worksheet with the relevant lines. The rows i wish to look at are over on the right hand columns of this new worksheet
it works ok but is cumbersome each time to scroll across. and then i need to delete the worksheet just created
Are there better way of doing this
Richard
I have a worksheet with a few thousand rows and about 25 columns arrive each week
The pivot on this data is really useful for me to interpret the data
when i wish to look at the underlying rows for a particularly value in the pivot by clicking on the value it opens a new worksheet with the relevant lines. The rows i wish to look at are over on the right hand columns of this new worksheet
it works ok but is cumbersome each time to scroll across. and then i need to delete the worksheet just created
Are there better way of doing this
Richard