Hi all,

I have data that's coming out into a regular excel table (2007), and I am trying to get another tab in the same workbook to display the data in these columns according to a template that has already been created. To add additional problems, the template itself has a limited number of rows available for its sections, but I would like the number of these rows to expand or contract depending on how many rows are in the original table in the other tab (this is a report that will run and could return a different set of values every time). Essentially, I want to make it so that every time I run this report from my other system and it updates the tab in the workbook I am using (via Connections), then the template in the other tab will also be updated. Does anyone have any ideas on what I can do, or is my description too confusing? Any help would be greatly appreciated!