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 Pls Share if you liked ! - :)
