Invoice Template and Database System

Basic techniques you can use to build your own macro:

1) Spot the next empty row in the database, then place values in that row

Please Login or Register  to view this content.

2) Copy the active sheet to a new workbook:

Please Login or Register  to view this content.

3) Save an Activeworkbook - Google up and use the GetSaveAsFilename method to save the active workbook

4) Clear values in a cell:

Please Login or Register  to view this content.

duplicate, sorry.

Put the below code in the Code Module of the Invoice worksheet and assign the Button1_Click macro to your button.

Please Login or Register  to view this content.

@PingPing - be careful using the xlCellTypeLastCell method to determine the last used row on a sheet. It will "usually" work, but Excel lies about that answer to that sometimes, and you'll find inexplicable gaps in the data recorded. Not a huge problem, more of an irritant, which is why I don't apply that method.

Thanks for the tip.

Originally Posted by PingPing

Put the below code in the Code Module of the Invoice worksheet and assign the Button1_Click macro to your button.

Please Login or Register  to view this content.

Thanks for your reply,

I tried to use it and it indeed does move the information into the database tab.

However, it does not clear the information from the original cells with the information in them, i need the original file to be cleared for the next person to input the next invoice. I intend to use this file as a template and a database so that my employees can use it to create invoices and I can use it to track invoices created.

Originally Posted by ROSH22

it does not clear the information from the original cells with the information in them, i need the original file to be cleared for the next person to input the next invoice.

That's trivial. Insert the following line at the end of the previous code:

Please Login or Register  to view this content.

kmp0511,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.