Help!!!!!

[OHIYO]

SHEET "july"

Images removed - They were blowing up the page - Moderator

It was essentially:

Month | Day1 | Day2 | Day3 | -->Day30
Qty -->

SHEET "aug"


SHEET "sept"


SHEET "report"

report

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 106px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center">DATE</TD><TD style="TEXT-ALIGN: center">QTY</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ffffcc">7/25/10</TD><TD style="TEXT-ALIGN: right">10</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">7/26/10</TD><TD style="TEXT-ALIGN: right">13</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">7/27/10</TD><TD style="TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">7/28/10</TD><TD style="TEXT-ALIGN: right">55</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">7/29/10</TD><TD style="TEXT-ALIGN: right">22</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">7/30/10</TD><TD style="TEXT-ALIGN: right">109</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">7/31/10</TD><TD style="TEXT-ALIGN: right">55</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">8/01/10</TD><TD style="TEXT-ALIGN: right">10</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">8/02/10</TD><TD style="TEXT-ALIGN: right">20</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">8/03/10</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 32px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">8/04/10</TD><TD style="TEXT-ALIGN: right">40</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">8/05/10</TD><TD style="TEXT-ALIGN: right">50</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">8/06/10</TD><TD style="TEXT-ALIGN: right">33</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">8/07/10</TD><TD style="TEXT-ALIGN: right">60</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">8/08/10</TD><TD style="TEXT-ALIGN: right">120</TD></TR></TBODY></TABLE>


I need to creat a 15 days report for production qty.
In the report sheet, I need to set a date on cell A2, then the result of qty list in column B.

Please help how to find it out?

yoyo

 

[Peter_SSs]

Peter,

what I mean is that I add one extra tab, namely data, which I recorded the production line information. This sheet format is not the same as sheets "jul","aug" or "sep"

Because of this extra sheet "data" added in the same workbook, the formula from Jasonb75 act in cell B2 didn't work properly, instead the outcome is #REF.

I hope you understand what I mean.

yoyo

Sorry, no I don't. The existing formula looks for a sheet based on a date in column A. I cannot see what a sheet called 'data' has to do with it.

Apart from not knowing how that sheet relates to the problem, you state that ...

This sheet format is not the same as sheets "jul","aug" or "sep"

... but you don't explain what the sheet format is like. Note Smitty's comment in your original post if you do want to post a screen shot to help explain.

 

[OHIYO]

I am so appreciated for the help from all of you.
I get it finally.

Thanks again.

Also, smitty, i got your attachments, thanks so much.

Yoyo