Hello - I have been trying to wrap my head around getting an indirect
formula that indexes rows to be printed to only recognize visible rows
so I can run a filter.

It's a little difficult to explain with my limited excel knowledge,
but if anyone cares to take a look at the excel file on this page.

http://spreadsheetpage.com/index.php...il_merge_demo/

I think that I have to add an extra formula to =INDIRECT("Data!A"
&RowIndex) so that it only recognizes rows that are visible, but not
quite sure.

Any expert insight is greatly appreciated. Thanks,

Chris