Invoicing Summary - Taking certain information from an invoice to add to another workbook

Hi All,

I am in the process of creating an invoicing program for work. Essentially I would like to capture some items of an invoice that can be collected on another worksheet (Let's Call it 'Reporting Page') to create an organized report. I would like to do this by creating a button

I would need to program the button so that it can capture and record the following on the 'Reporting Page':
- Invoice Number
- Date
- Customer
- Quantities for the certain items that are purchased.

What I would also need to have done is that with every new invoice I create that the information can be properly recorded in the next column on the 'Reporting Page'.

Please help. I am new in this forum but have seen how helpful this website truly is.

Do you have an invoice template developed? Have you gotten anywhere with creating the formatting of the workbook?

If so, upload a copy so that we all can see what we are working with.

Here is the worksheet I'm working off of. I have set up the template how I would like to track the info on two worksheets but I have not applied a Macro to the button.

Thanks for all the help you.

Any luck with this problem? Did you need any more information?

Hi Domgee,

Try using the following code and let me know if it has the desired result>

Please Login or Register  to view this content.