VBA Code for Job Costing

[Gmil]

Hi, I have set up a workbook for Job Costing. My "Product Sheet" and the Job Sheets are all in (1) Workbook. Each worksheet is named as the Job Number.
I have a set the Job Sheets up with VLookup =IF(B21="","",(VLOOKUP(B21,'Product Code'!$B$4:$D$188,2,FALSE))) to find the products and price them at a rate on the Product Sheet. The products on each sheet varies.

Thanks to this forum I use a VBA Code to automatically name the worksheets from a list, and another code to automatically create hyperlinks from the worksheets names.

On the Product Sheet I have a total Qty =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheetlist&"'!$B$21:$B$58"),B5,INDIRECT("'"&Sheetlist&"'!$I$21:$I$58"))) for occurances of each product for all worksheets.

I have now set up worksheets for each product, but want to populate these worksheets with a list of all occurrences of the product listing Job Number (Worksheet Name), Customer, Qty, Rate and Total.



Any Suggstions?

Thanks in advance

[Leith Ross]

Hello Gmil,

Welcome to the forum!

Because there is some much referencing involved, you should post a copy of the workbook. This will allow development of a working solution for you much more quickly. If your workbook contains confidential information, please redact it before your post.

To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Pic

[Gmil]

Please find attached file as requested.
Goto Product Index to hyperlink to product worksheets.
I will insert code into each sheet, but a start would be helpful.
The workbook is usually protected by a global code.
I am new to formulas and codes.

Thanks