isabel1217
Board Regular
- Joined
- Sep 23, 2005
- Messages
- 100
Hope you could help me, I wanted to transfer information from one sheet to another to answer the condition that I want. This is table one below on sheet 1.
Sheet 1
1 A B C D E F G H I J K L M N O P
2 Client No. 18/07/2015 19/07/2015 20/07/2015 21/07/2015 22/07/2015 23/07/2015 24/07/2015 25/07/2015 26/07/2015 27/07/2015 28/07/2015 29/07/2015 30/07/2015 31/07/2015 1/08/2015
3 111 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00
4 222 10:00 8:00 8:00 8:00 10:00 10:00 8:00 8:00 8:00 10:00 10:00 8:00 8:00 8:00 10:00
5 333 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00
6 444 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00
7 555 Dayoff 17:00 17:00 17:00 Dayoff Dayoff 17:00 17:00 17:00 Dayoff Dayoff 17:00 17:00 17:00 Dayoff
8 666 Dayoff 5:30 5:30 5:30 Dayoff Dayoff 5:30 5:30 5:30 Dayoff Dayoff 5:30 5:30 5:30 Dayoff
9 777 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00
Sheet 2
A3 - Client No. - 111
B3 - Starting Date - 20/07/15
C3 - Ending Date - 30/07/15
What is the formula extracting datas from Sheet 1 to Sheet 2 based from the information for Client 111 from starting date to Ending Date.
The result would be like this.
Client No. 111 Starting Date 20/07/15 - 30/07/15
20/07/2015 21/07/2015 22/07/2015 23/07/2015 24/07/2015 25/07/2015 26/07/2015 27/07/2015
8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00
Sheet 1
1 A B C D E F G H I J K L M N O P
2 Client No. 18/07/2015 19/07/2015 20/07/2015 21/07/2015 22/07/2015 23/07/2015 24/07/2015 25/07/2015 26/07/2015 27/07/2015 28/07/2015 29/07/2015 30/07/2015 31/07/2015 1/08/2015
3 111 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00
4 222 10:00 8:00 8:00 8:00 10:00 10:00 8:00 8:00 8:00 10:00 10:00 8:00 8:00 8:00 10:00
5 333 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00
6 444 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00
7 555 Dayoff 17:00 17:00 17:00 Dayoff Dayoff 17:00 17:00 17:00 Dayoff Dayoff 17:00 17:00 17:00 Dayoff
8 666 Dayoff 5:30 5:30 5:30 Dayoff Dayoff 5:30 5:30 5:30 Dayoff Dayoff 5:30 5:30 5:30 Dayoff
9 777 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00
Sheet 2
A3 - Client No. - 111
B3 - Starting Date - 20/07/15
C3 - Ending Date - 30/07/15
What is the formula extracting datas from Sheet 1 to Sheet 2 based from the information for Client 111 from starting date to Ending Date.
The result would be like this.
Client No. 111 Starting Date 20/07/15 - 30/07/15
20/07/2015 21/07/2015 22/07/2015 23/07/2015 24/07/2015 25/07/2015 26/07/2015 27/07/2015
8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00