Populate Data Based on Criteria

[kumara_faith]

Hi,

I have the following table in sheet 1:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
2	Table 1
3	Month	Date	Branch	Staff	Task1	Task2	Task3	Task4	Task5	Task6	Task7	Task8	Task9	Task10	Task11	Task12	Task13	Task14	Task15	Task16	Task17	Task18
4	Jan	Monday, 2 January, 2023	Texas	Staff1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
5	Jan	Tuesday, 3 January, 2023	New York	Staff2	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
6	Jan	Wednesday, 4 January, 2023	Oklahoma	Staff3	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
7	Feb	Wednesday, 1 February, 2023	Texas	Staff1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
8	Feb	Thursday, 2 February, 2023	New York	Staff2	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
9	Feb	Friday, 3 February, 2023	Oklahoma	Staff3	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
10	Mar	Wednesday, 1 March, 2023	Texas	Staff1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
11	Mar	Thursday, 2 March, 2023	New York	Staff2	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
12	Mar	Friday, 3 March, 2023	Oklahoma	Staff3	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
Sheet1

In Sheet 2, I have the following table where I would likeusers can enter the crietria:

Book1
	B	C	D	E	F
15	Table 2
16	Month	Branch	Staff	Start Date	End Date
17	Jan	Texas	Staff1	2/1/2023	3/3/2023
Sheet1

The correct result should populate as below in Table 3:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
20	Table 3
21	Month	Date	Branch	Staff	Task1	Task2	Task3	Task4	Task5	Task6	Task7	Task8	Task9	Task10	Task11	Task12	Task13	Task14	Task15	Task16	Task17	Task18
22	Jan	Monday, 2 January, 2023	Texas	Staff1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
23	Feb	Wednesday, 1 February, 2023	Texas	Staff1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
24	Mar	Wednesday, 1 March, 2023	Texas	Staff1	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10	10
Sheet1

Is there a way to build formula in Table 3 to populate data based on the criterias entered in Table 2 in Table 3? Appreciate all the help.

 

[kumara_faith]

Hi Fluff,

That worked. Thank you for your patience. Appreciate it and have a great day ahead.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[kumara_faith]

Hi,

The solution above populates the desired the data output based on the criteria. When the user selects for a long range, say a few months, we would like to be able to filter the data as well. Currently we are copying and pasting into a new sheet to be able to do that. Is there a way to be able to use the Data>>Filter in the original output itself?

 

[Fluff]

Yes you can do that.