inese_green
New Member
- Joined
- Apr 21, 2021
- Messages
- 6
- Office Version
- 2016
- 2013
- Platform
- Windows
Hello! I hope you can all help me with my work. I'm working with multiple sheets, and the count of the sheets are variable. I have the main sheet DATA, and sheet2, sheet3....Sheets contain the same information, except the unique number of samples (Lab. No), what are changing. I need to get information from other sheets to DATA sheet, based on criteria (Lab. No). It would bring from sheet2, sheet3....exact values based on LAb. No. what is on Data sheet.
Like, for Lab. No. 123A456 it would bring for particle diameter 16.0 mm - 4.0, for 11.2 mm - 5.0...so on...
I'm wondering, is it possible to write formula what would fit for variable number of sheet? I I have 2 or 10 sheets, it can bring in Data sheet values based on Lab. No. from multiple sheets.
I hope, I set out clearly what I want to achieve!
Have a nice day!!!
Like, for Lab. No. 123A456 it would bring for particle diameter 16.0 mm - 4.0, for 11.2 mm - 5.0...so on...
I'm wondering, is it possible to write formula what would fit for variable number of sheet? I I have 2 or 10 sheets, it can bring in Data sheet values based on Lab. No. from multiple sheets.
I hope, I set out clearly what I want to achieve!
Have a nice day!!!