Hi
Take a look at Advanced Filter.
Debra Dalgleish has some excellent examples and downloadable files at
http://www.contextures.com/xladvfilter01.html#ExtractWs
http://www.contextures.com/ProductsListOrder.zip
--
Regards
Roger Govier
"Wombat" wrote in message
...
Hello and a happy New Year to all excel enthusiasts!
I've got a question to start the year off:
I've got a database on a tab of my worksheet (called "database") from
which
I want informations to be extracted into another table on a different tab
(called "orders").
What I want to happen is this:
- I input the individual number of one of the articles on the "Orders" Tab
in cell A1
- run the macro
- relevant information is taken from the database and inserted into the
new
table (eg. today's date, brand, price, etc.)
- the individual number is deleted out of the original A1 cell
Can anyone help me? I realise excel is probably not the right program for
this but I cant use acess and this is only for a small project.
Thanks for any help!
__________ Information from ESET Smart Security, version of virus
signature database 4759 (20100110) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4760 (20100111) __________
The message was checked by ESET Smart Security.
http://www.eset.com