So ... I have now determined I need to "get data" and place it directly into a new table for a reporting form I am creating. The number of rows changes as items are added and deleted. The data entry tab ( in a separate workbook ) contains no total bar at the bottom; the reporting tabs are where those should live. I know how to lock in the row height and column width of the query table itself after "getting data" and refreshing. However, my total row below the table does not dynamically adjust. The 1/2"-tall row either gets lost inside the table ( when rows are added ) or disappears far below the table ( when rows are deleted ). How do I get that total bar to move and lock with the table? Its data and fill color adjust just fine. So far, I have only noticed a issue with the row's height.
Bookmarks