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