Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting information from a database with a macro
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting information from a database with a macro
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with filtering & inserting information :( | Excel Worksheet Functions | |||
Inserting information from One Sheet to Many | Excel Worksheet Functions | |||
Inserting information into a unmade row with a macro | Excel Discussion (Misc queries) | |||
INSERTING INFORMATION IN A CELL | Excel Discussion (Misc queries) | |||
Database Information | Excel Worksheet Functions |