Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to save information into a table
Hello and happy new year to all Excel enthusiasts!
Got a question to start off the year: I have a database on one tab (called "database") of my workbook with items which have an individual number. I'd like to have a macro which saves information into a table on another tab (called "orders") each time this individual number is entered in a cell. Eg: - I would type in the number - run the macro - infos such as date, name of the article, etc. are inserted in a table - the cell with the article number is wiped blank The part I'm mostly unsure about is how you could insert the new information without writing over the older entries. I realise excel probably isnt the best program to do this in, but this is a very small scale project and I dont know how to use access! Thanks for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to save information into a table
see response to your later posting
-- Regards Roger Govier "Wombat" wrote in message ... Hello and happy new year to all Excel enthusiasts! Got a question to start off the year: I have a database on one tab (called "database") of my workbook with items which have an individual number. I'd like to have a macro which saves information into a table on another tab (called "orders") each time this individual number is entered in a cell. Eg: - I would type in the number - run the macro - infos such as date, name of the article, etc. are inserted in a table - the cell with the article number is wiped blank The part I'm mostly unsure about is how you could insert the new information without writing over the older entries. I realise excel probably isnt the best program to do this in, but this is a very small scale project and I dont know how to use access! Thanks for any help! __________ Information from ESET Smart Security, version of virus signature database 4760 (20100111) __________ 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 | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
Can you save add-ins information in a spreadsheet? | Excel Discussion (Misc queries) | |||
Can you save add-ins information in a spreadsheet | Excel Worksheet Functions | |||
Can I get Excel not to save a file if certain information is not i | Excel Worksheet Functions | |||
how to save and print information | Excel Worksheet Functions |