| 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 | |||
Hybrid Mode
