PDA

View Full Version : Dataset updates changing the pivot table



764sno
09-22-2017, 03:22 AM
Excel 2016.
Hi! I am completely new to VBA and wondering what codes to use - the thing is that I have an dataset that gets bigger over time. These additional lines of data gets added at the end of the dataset every month and the optimal thing for me would be if this updated dataset automatically updated the pivot table which in turn updated the different cash flows/figures. Can you please help me get started?

austenr
09-22-2017, 02:25 PM
if you post a sample workbook someone could help you. an idea is to make your dataset a named range.



Heres a tutorial to help you.

https://www.extendoffice.com/documents/excel/1335-excel-create-dynamic-range.html