Address function to create a range

**aria6506** · 11-13-2018, 12:30 PM

Hello, I am new to the group and excel formula and VBA. I have a template I am using to create a dynamic drill down. The template uses the drill down to create a graph (using only 2 columns of data). I would like to create a table (based on the drill down filters) instead of a graph using 3 columns of data. I need help using address function to create a range. The formula I THINK I need to change is in attached> xlsx Pivot tab> columns S&T. I have also attached a PDF with what I want and what I have. Any guidance is greatly appreciated.

**6StringJazzer** · 11-13-2018, 02:15 PM

The only thing attached is images. An image attachment has very little value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.