Summary Sheet for my Invoice workbook

Hi All,

We use excel for generating invoices.

We need a capture key data form different cells in an invoice and make an auto updating summary sheet in the same work book.
Please note that all the worksheets are renamed with the Invoice number.

The workbook will typically have around 100 work sheets (Invoices).

Can anybody help me with it.

THank you in advance.

Jayesh Mehta
e-mail: removed

Hi Jay and welcome to the forum,

Many of our members can help with this kind of problem. You should give us an example showing what you have and what your summary sheet should look like. If you do a workbook of about 5 sheets only and attach it showing what your summary looks like along with what the invoice sheet looks like, we can work on the problem.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Marvin,

Appreciate your quick response.

As suggested by you I am attaching my workbook along with summary sheet with all the required field as the first sheet.

Please help in getting it automated.

Thanks a lot.

Jayesh Mehta
e-mail:removed

Unless you want tons of SPAM in your inbox, it really isn't a good idea to advertise your E-mail address on a public forum. As nobody is going to use it, anyway (the entire process of your getting help stays here on the forum), I have removed the link.

Even if I wanted to, which I don't, I do not have administrator privileges so cannot tamper in any way with your account! I have done simply what I stated clearly at the end of my post: I have removed your E-mail link from your posts in this thread. Have a look and see!