Thread: How to add PivotTable drop down selector to another tab?
View Single Post
  #28 (permalink)  
Old 01-29-2008, 06:27 AM
BurgoEng BurgoEng is offline
Junior Member
  
Join Date: Oct 2007
Posts: 28
iTrader: (0)
BurgoEng is on a distinguished road
Default
Take a look at the OFFSET function along with COUNTA.

You should end up with something like...

=offset(Sheet1!$A$1,counta(yourrange)-11,0,12,number of columns in range)
Reply With Quote