Hi
I am hoping someone can help me with this problem.
I am quite new to using excel and tend to learn from working through
things on my own and using tips on site like this to try and point me
in the right direction.
I have managed to create some pivot tables and several rows below this
I have a table feeding from this information which ultimately feeds
through to a summary page. My problem is that when the pivot table
increases or decrease in rows numbers (it won't ever increase in column
numbers) the table below does not recognise this.
I have not fixed the formula in the lower tables,
Is there any way I can create this link to avoid the need to manually
update the formula in the lower table.
Thanks in advance for any help you can all give.
WeeClaire


--
weeclaire
------------------------------------------------------------------------
weeclaire's Profile: http://www.excelforum.com/member.php...o&userid=28738
View this thread: http://www.excelforum.com/showthread...hreadid=485803