Extract info from excel 2010

**stevejbailey** · 08-01-2013, 07:22 AM

My document is for a building project funds draw down. The doc contains a number of worksheets that are titled for different areas of works.

Some suppliers invoices are under different categories.

Example.
Supplier - Interline
Invoice No. xxxxxxxx is under worksheet 'BLOCKWORK' with its associated invoice amount and VAT amount.
Invoice No. xxxxxxxx is under worksheet 'PLUMBING' with its associated invoice amount and VAT amount.

My question is.
Can i extract any information related to invoices that contain 'interline' and its associated amounts to either a new excel doc or worksheet.

Hope i have explained myself well enough, unlike my last request.

**Debraj Roy** · 08-01-2013, 07:31 AM

explained myself well enough

you can do better explanation.. with a sample workbook..

**stevejbailey** · 08-01-2013, 08:04 AM

Not sure how to attach a workbook

**arlu1201** · 08-01-2013, 08:28 AM

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**arlu1201** · 08-01-2013, 08:28 AM

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.