I have two pivot tables in one worksheet range from A5 to D15 and A17 to D25.
Each time I update the data, I will goto "Refresh Data" in pivot data. If there is an additional product being key-in, the pivot table would extend from A5 to D18. That meant it would overlap the data in A17 to D25. Therefore, I would like to know is that any VBA code that can be used to ensure that there must be at least 2 empty rows being the above pivot table.