Everyday, I add data , which feeds about 10 pivot tables. I have them formatted by date for the rows, and the different companies that own the oil well, the name of the well, then the companies that haul the oil, for the columns and volume each day for values. I have each company color coded vertically, and bordered as I like. The problem is, after I refresh the tables, it does not update to include the new dates, and it loses the color and border format, and I have to go update every table. Is there a way to have it refresh the new data, and apply the same format each time with either VBA or a Macro?
Bookmarks