Copy cells to a new sheet based on a specific date.

[Korena]

What's the best way to do this?


I need to create a Daily Summary Report based off of the info I enter on the Monthly Production Sheet. I am wanting to just enter in the date at the top of a blank template and have that days info pop in. I'm at a lost of how to do this.

Thanks!

 

[Nine Zero]

alright lets start with some information

-How is the data structured in the Monthly Production Sheet?
-What are the headers
-Is what you are wanting like some kind of filter to only view a specific date?

example

Monthly Production

	A	B	C	D	E	F	G	H	I
1	Date	Item	Qty	Price	X	Y	Z	A	B
2	01/01/18	101	10	5.23	1	23	52	4	1
3	02/02/18	102	25	6.24	1	2		3	5
4	02/02/18	506	67	7.56	2	5	42	4	5
5	02/02/18	555	64	5.87	5	5	5	5	5
6	03/01/18	654	45	4.50	5	5	5	55	5
7
8
9

<tbody>
</tbody>

And you want a Daily sheet that does this

	A	B	C	D	E	F	G	H	I
1	Enter A Date	02/02/18
2	Date	Item	Qty	Price	X	Y	Z	A	B
3	02/02/18	102	25	6.24	1	2		3	5
4	02/02/18	506	67	7.56	2	5	42	4	5
5	02/02/18	555	64	5.87	5	5	5	5	5
6
7
8
9

<tbody>
</tbody>

Something like that?

Maybe create a simple pivot table?

 

[Korena]

Sorry to be so simple. How do I show you part of my work book on here? Thanks