Macro to save information into a table

W

Wombat

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!
 
R

Roger Govier

see response to your later posting

--
Regards
Roger Govier

Wombat said:
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
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4760 (20100111) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting information from a database with a macro 1
Setting column width in a table with a macro is not working 0
Macro to copy table of contents to a new doc 0
Creating a Search using a combo box and then creating a report. 4
Macro to select and delete levels of a document 2
Menu Macro Not Executing - Need Help 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Insert Index into a Table 1

Top