I have a vba code that populates the excel tables across the worksheets in a workbook.
Most of the work Worksheets have single table. The code works fine and tables expand and contract based on the fetched data columns and rows.
One of the worksheets have two adjacent tables. I want to expand the 1st table in such a way that the second table gets pushed out(shift right) to accommodate the data of the 1st table. Also if the data fetched has lesser columns then the second table should shift left. So that both tables are always adjacent to each other.
Attaching the scenarios.