you can use Auto Filter initally and copy those nonblanks data to a new
workbook
and put a Vlookup or Index and Match formula to populate the updated data.

HTH
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Dave H" wrote:

How can one pull data from nonblank cells from Workbook #1 to Workbook#2 and
have it popluate when new data is added to Worksheet #1?
Thanks