Possibly using Data = Filter = Advanced Filter

--
Regards,
Tom Ogilvy

" wrote
in message ...
Can I populate the sheet with the data from a different sheet of the book
based on the value of the data on the sheet from one of the columns.
Something like
INsert into .....
select * from ....
where ....