Adding Number into the generated Report

[laxmananm]

Hi,

Please see the attachment. Containing system generated report.
But I need the part numbers in each sheet Column D. and Column E as quantity.
To be pasted in new created sheet name Master. Looks as shown in the Partnumber_format sheet.
I have to copy all the part number are in columd D in each sheet and generate result in new sheet name as master.

Thanks,
lax

[laxmananm]

Can anyone please give me the idea to complete this..is it possible automate?

[laxmananm]

Dear excel masters,

Please help me to update the attached sheet..waiting for your valuable comments

Thanks,
Lax

[laxmananm]

can anyone please have a look on this thread

[laxmananm]

Can anyone please help me

[SamT]

Most of the information we need is in this very small attachment. You must put all possible Part numbers in the sheet "Master List of Part Numbers" for us.

To everybody: There are ~100 sheets in the original Test23.xlsx attachment in post 1 above.

[laxmananm]

Thanks Sam.I have done this with my own..anyway thanks for the advice and response..

lax

[SamT]

:thumb