Combine, lookup and insert data

Its a big one, so this is only if you are bored...I will get it myself eventually.
Or just some rough advice would be cool.

OK seems to me like we are doing the same thing over and over, but thats what the man wants, so thats what he gets!


I am doing the WORKINGS sheet in the attached workbook.

First I need to combine the week totals on the VOLUME sheet for each product.
(the weeks to be added are input in WORKINGS sheet D4 & D5)

Each product is made up of a "casting" and a "backing plate" and sometimes other components too.
I need to look up the products using the PRODUCT LIST sheet to make a list of total components required (some products use the same components).
Column A is the product, G is the casting, I is the backing plate, then also K to P which also have qunatities.

Then combine similar components, adding the totals (if not already done).

Then put them into the correct row of the WORKINGS sheet (column E).

Hi

Put the code below in a general module, select the workings sheet, and run.

It uses the blank columns A and B during processing, so these will have to remain unused.

rylo

Please Login or Register  to view this content.

You never cease to amaze me!

Thanks mate.



It had problems with the subheadings like BACKING PLATES in column C so I just took them out, no worries.
It also deleted the column header in E so I just added that back again after.

Hi

Interesting. I used the sample file you put up, and worked with that structure / data. The column C headings were accommodated (it didn't process these) and it didn't remove headings from column E.

Did you try it on the file that you put up as a sample?


rylo

Auggh..

Just realised.

1) I ran this with sample data so the delete will have taken out part of the heading when there was no data. Modified for this.

2) You have to make sure the headings on Product List exactly match the headings in column C. I forgot to mention that...

Please Login or Register  to view this content.

rylo

No problem.
Thanks again.