Post record to database

[Aland2929]

I am capturing data to post to a database and the first field is the month which is selected from a drop-down list. When I post the record, column A in the database shows a drop down list for the month. How do I remove the drop-down in the database?
Thanks in advance

[Izandol]

What is the database?

[Aland2929]

I am capturing a record (8 cells of data with a range name) in Sheet1 which gets posted to Sheet2 which is the Database.

[Izandol]

How do you "post" the record? Copy and paste? If it is so, you may paste special values instead.

[Aland2929]

This is the code I am using:

Please Login or Register  to view this content.

[Izandol]

You may try:

Please Login or Register  to view this content.

[Aland2929]

Thanks very much. It works great but the date is shown as a value in the database. How can I convert it to MMYY when posting?

[Izandol]

May you format the database column beforehand? Then the code will work.

[Aland2929]

Perfect. Thanks very much.

[Izandol]

You are welcome.