I have a workbook with several worksheets.  One worksheet is linked to
another and the first column of the target worksheet has an AutoFilter of
Nonblank.  When I choose Nonblank from the drop down, it populates several
columns of information form the target spreadsheet.  New columns have been
added to the source spreadsheet, how do I get them to populate in the target
spreadsheet?

Thanks, in advance, for anyone's assistance.

Joli