0

Define Pivot table Dynamic Data Range running NL("rows")

Jet Reports Historic Posts

June 27, 2013 20:48

None

Follow

Hi,
How would I define Pivot table Dynamic Data Range so when running NL("rows") I don't need to manually update data source on every run? I use Excel 2010, Jet Essentials. Thank you.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 01, 2013 06:10

  Hi
  One way you can do it, im sure there are more, is to select the NL("rows") - Row, and the row below that one (I think its called the anchor row).
  Define a named range for theese two rows, now u can reference to this area in youre pivot table.
  
  Does help you ?
  
  Best regards
  Søren

• 1
  
  Jet Reports Historic Posts July 01, 2013 09:09

  Hi,
  
  I have been using this method which works quite well so far.
  Check this link
  http://www.youtube.com/watch?v=mXOUxcnHgAQ
  
  Regards
  
  Tom

• 0
  
  Jet Reports Historic Posts July 04, 2013 21:11

  Hi,
  Soren, Tom, thank you. The video really helped as I did not have experience in creating dynamic ranges. It works for me now. Thank you again.