This video teaches add pivot table with dynamic range if new column or row inserted in source also will clarify the offset function's use br br Please share if you liked this video, thanks a lot ! :)