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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Item[/TD]
[TD]Qty[/TD]
[TD]Price[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]01/01/18[/TD]
[TD]101[/TD]
[TD]10[/TD]
[TD]5.23[/TD]
[TD]1[/TD]
[TD]23[/TD]
[TD]52[/TD]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]02/02/18[/TD]
[TD]102[/TD]
[TD]25[/TD]
[TD]6.24[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]02/02/18[/TD]
[TD]506[/TD]
[TD]67[/TD]
[TD]7.56[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]42[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]02/02/18[/TD]
[TD]555[/TD]
[TD]64[/TD]
[TD]5.87[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]03/01/18[/TD]
[TD]654[/TD]
[TD]45[/TD]
[TD]4.50[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]55[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


And you want a Daily sheet that does this

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Enter A Date[/TD]
[TD]02/02/18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Date[/TD]
[TD]Item[/TD]
[TD]Qty[/TD]
[TD]Price[/TD]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]02/02/18[/TD]
[TD]102[/TD]
[TD]25[/TD]
[TD]6.24[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]02/02/18[/TD]
[TD]506[/TD]
[TD]67[/TD]
[TD]7.56[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]42[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]02/02/18[/TD]
[TD]555[/TD]
[TD]64[/TD]
[TD]5.87[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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