Combine multiple sheets

Hello,

Please find attached sample sheet for more details. I have 5 shops inventory sheets and I need to combine C row in sheet3!

thank you!

I combined the C row from every sheet with help from a "help sheet". This can only be done if the lists are exactly identical.

See attached workbook.

Originally Posted by Special-K

What "more details" do you expect us to see in the spreadsheets?
All you have are 6 spreadsheets with no details explaining what you're trying to achieve.
What does "combine" mean to you?

hello

I have inventory for each shops and I need to see how many items we have in all shops. I want to see how many totals “yes” we have and I want to combine all columns C in sheet 3. Hope you understand.

Thanks for your help

Originally Posted by sanam

hello

I have inventory for each shops and I need to see how many items we have in all shops. I want to see how many totals “yes” we have and I want to combine all columns C in sheet 3. Hope you understand.

Thanks for your help

I think no another solution for this.

Thank you

Originally Posted by sanam

I think no another solution for this.

Thank you

hello,
I am still waiting for any kind of solution

thank you