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

The only way I know to do it is to select nonblank from the drop down
again.


Joli Wrote:
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


--
GaryE
Posted from - http://www.officehelp.in