hi
I have next need:
People are working in shifts.every sheet is one shift.
sheet names are like this
6-14 (1)
14-22 (1)
22-06 (1)
6-14 (2) etc
you can see that 6-14 means people work from 6 to 14 and (1) means day one of the month.
as you can guess there are 31 days, so it means there are 93 sheets.
In every sheet i have 15 columns with 25 rows: column A operator names,B=working minutes,C=quantity of prdoucts and so on.
I need to gather some columns like quantity of products and put them all into one sheet one under another. So it will be Column A 25 rows from sheet 6-14(1) then next 25 rows from 14-22 (1) and so on. As you can see if I would manually select every cell in report sheet I would need to do 93x25x20 cells. Not really intelligent way to do it. I am already working with this formula and then just pulling it down:
=INDIRECT("'6-14 ("&INT((ROWS(C$3:C3)-1)/25)+1&")'!$q7") but I am having problems to finish it correctly.
basically I want to insert formula in Cell A1 of report sheet and just pull down 2325 rows.
Any help?
I have next need:
People are working in shifts.every sheet is one shift.
sheet names are like this
6-14 (1)
14-22 (1)
22-06 (1)
6-14 (2) etc
you can see that 6-14 means people work from 6 to 14 and (1) means day one of the month.
as you can guess there are 31 days, so it means there are 93 sheets.
In every sheet i have 15 columns with 25 rows: column A operator names,B=working minutes,C=quantity of prdoucts and so on.
I need to gather some columns like quantity of products and put them all into one sheet one under another. So it will be Column A 25 rows from sheet 6-14(1) then next 25 rows from 14-22 (1) and so on. As you can see if I would manually select every cell in report sheet I would need to do 93x25x20 cells. Not really intelligent way to do it. I am already working with this formula and then just pulling it down:
=INDIRECT("'6-14 ("&INT((ROWS(C$3:C3)-1)/25)+1&")'!$q7") but I am having problems to finish it correctly.
basically I want to insert formula in Cell A1 of report sheet and just pull down 2325 rows.
Any help?
