Raw data changes size every day

[Daron]

Hi,

I'm after some help/guidance on a problem I have...

I have a report I produce on a daily basis, every day I extract the data from a report produced and copy it into a data sheet in excel.

The number of rows can vary each day so I then have to refresh 6 pivot tables running from this data and go into each one changing the data source.

Is there a way to automate this in VBA using Named Ranges?


Any help really appreciated.

Thanks

 

[Joe4]

Welcome to the Board!

Yes, if you use Named Ranges for your Pivot Tables, you can use VBA to resize your named ranges each day.
See here: https://www.mrexcel.com/forum/excel-questions/1000034-resize-named-range.html

 

[Kyle123]

You could also simply format your data as a table