Not a clue

[smm3]

I've been trying to figure this out, but don't know where to begin.
I have bingo winners for each month. I have amounts won in each dated column. I have end of the month totals. I need to find a macro (I think) that can take each different person with monthly totals and put them on another worksheet each and every month. I will have different names in different months. I need ongoing totals for each person for the entire year. Gosh, I hope this makes sense.
Thanks for any help at all!
Vickie

Jan 1/2/2011 1/5/2011 1/25/2011 1/30/2011 Total
Adams, Doug $258.00 $15.00 $55.00 $25.00 $353.00
Adams,Linda $90.00 $25.00 $110.00 $115.00 $340.00
Adams, Myrna $900.00 $30.00 $0.00 $30.00 $960.00
Adamson, Wade $0.00 $5.00 $85.00 $250.00 $340.00
Alderman, Suzan $60.00 $115.00 $25.00 $0.00 $200.00
Alick,Tish $0.00 $250.00 $0.00 $60.00 $310.00
Allison, Amanda $0.00 $15.00 $0.00 $25.00 $40.00
Alves, Susan $50.00 $25.00 $0.00 $260.00 $335.00

Feb 2/1/2011 2/11/2011 2/15/2011 2/25/2011 Total
Brand, Cecilia $54.00 $60.00 $8.00 $85.00 $207.00
Briere,Elizabeth $25.00 $15.00 $50.00 $0.00 $90.00
Brookreson, Del $250.00 $0.00 $30.00 $13.00 $293.00
Brownlee, Nancy $85.00 $0.00 $30.00 $260.00 $375.00
Buck, Elsie $15.00 $60.00 $115.00 $60.00 $250.00
Buck, Pat $15.00 $0.00 $260.00 $85.00 $360.00
Bulmore, Ray $115.00 $30.00 $15.00 $50.00 $210.00

March 3/5/2011 3/10/2011 3/15/2011 3/21/2011 Total
Alderman, Suzan $40.00 $0.00 $30.00 $0.00 $70.00
Alick,Tish $50.00 $15.00 $85.00 $15.00 $165.00
Allison, Amanda $30.00 $30.00 $85.00 $0.00 $145.00
Boeing, Francine $85.00 $30.00 $50.00 $59.00 $224.00
Bush, Rita $159.00 $85.00 $50.00 $260.00 $554.00
Buttler, Jim $115.00 $15.00 $0.00 $85.00 $215.00
Cappelli, Joe $0.00 $85.00 $50.00 $50.00 $185.00
Capplli, Heather $50.00 $15.00 $115.00 $30.00 $210.00

 

[smm3]

Sorry I can't make it look any better.

1/2/2011 1/5/2011 1/25/2011 1/30/2011 Total
Adams, Doug $258.00 $15.00 $55.00 $25.00 $353.00
Adams,Linda $90.00 $25.00 $110.00 $115.00 $340.00
Adams, Myrna $900.00 $30.00 $0.00 $30.00 $960.00
Adamson, Wade $0.00 $5.00 $85.00 $250.00 $340.00
Alderman, Suzan $60.00 $115.00 $25.00 $0.00 $200.00
Alick,Tish $0.00 $250.00 $0.00 $60.00 $310.00
Allison, Amanda $0.00 $15.00 $0.00 $25.00 $40.00
Alves, Susan $50.00 $25.00 $0.00 $260.00 $335.00

2/1/2011 2/11/2011 2/15/2011 2/25/2011 Total
Brand, Cecilia $54.00 $60.00 $8.00 $85.00 $207.00
Briere,Elizabeth $25.00 $15.00 $50.00 $0.00 $90.00
Brookreson, Delpha $250.00 $0.00 $30.00 $13.00 $293.00
Brownlee, Nancy $85.00 $0.00 $30.00 $260.00 $375.00
Buck, Elsie $15.00 $60.00 $115.00 $60.00 $250.00
Buck, Pat $15.00 $0.00 $260.00 $85.00 $360.00
Bulmore, Ray $115.00 $30.00 $15.00 $50.00 $210.00

3/5/2011 3/10/2011 3/15/2011 3/21/2011 Total
Alderman, Suzanne $40.00 $0.00 $30.00 $0.00 $70.00
Alick,Tish $50.00 $15.00 $85.00 $15.00 $165.00
Allison, Amanda $30.00 $30.00 $85.00 $0.00 $145.00
Boeing, Francine $85.00 $30.00 $50.00 $59.00 $224.00
Bush, Rita $159.00 $85.00 $50.00 $260.00 $554.00
Buttler, Jim $115.00 $15.00 $0.00 $85.00 $215.00
Cappelli, Joe $0.00 $85.00 $50.00 $50.00 $185.00
Capplli, Heather $50.00 $15.00 $115.00 $30.00 $210.00

 

[Dryver14]

Sheet1

<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: 96px"><COL style="WIDTH: 79px"><COL style="WIDTH: 64px"><COL style="WIDTH: 70px"><COL style="WIDTH: 77px"><COL style="WIDTH: 64px"><COL style="WIDTH: 75px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 78px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><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><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Name</TD><TD>Jan</TD><TD>Feb</TD><TD>Mar</TD><TD>Apr</TD><TD>May</TD><TD>Jun</TD><TD>Jul</TD><TD>Aug</TD><TD>Sep</TD><TD>Oct</TD><TD>Nov</TD><TD>Dec</TD><TD>Grand Total</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt">Adams,Doug</TD><TD style="TEXT-ALIGN: right">£ 353.00 </TD><TD style="TEXT-ALIGN: right">£ 550.00 </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">£ 903.00 </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Adams, Linda</TD><TD style="TEXT-ALIGN: right">£ 340.00 </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">£ 516.00 </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">£ 856.00 </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Adams, Myrna</TD><TD style="TEXT-ALIGN: right">£ 960.00 </TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">£ 960.00 </TD></TR></TBODY></TABLE>


I assume you want page 2 to look like this but i can not fully understand page 1 layout to gather the info, on one example you write the month on
next example you dont

 

[smm3]

Yes that looks good. The problem is i have some many different winners it would take me months to create the final form manually.

Vickie

 

[Dryver14]

my starting point would be on page one to select row A:A and filter . advanced filter select unique records and copy to new destination, select cell A1 on page 2 and press ok.

this will give you a good starting point as you now have all the names listed once.

 

[Matt Rogers]

Hi.

Maybe tis?

Data
Text in columns
Separated
Other = $
Ok
Ok

Result:
<table style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; " border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight:bold; width:30px; "><col style="width:125.6px;"><col style="width:83.2px;"><col style="width:83.2px;"><col style="width:83.2px;"><col style="width:83.2px;"><col style="width:83.2px;"></colgroup><tbody><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td>
</td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td></tr><tr style="height:22px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">2</td><td>Adams, Doug </td><td style="text-align:right; ">258.00 </td><td style="text-align:right; ">15.00 </td><td style="text-align:right; ">55.00 </td><td style="text-align:right; ">25.00 </td><td style="text-align:right; ">353.00</td></tr><tr style="height:22px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">3</td><td>Adams,Linda </td><td style="text-align:right; ">90.00 </td><td style="text-align:right; ">25.00 </td><td style="text-align:right; ">110.00 </td><td style="text-align:right; ">115.00 </td><td style="text-align:right; ">340.00</td></tr><tr style="height:22px ;"><td style="font-size:8pt; background-color:#cacaca; text-align:center; ">4</td><td>Adams, Myrna </td><td style="text-align:right; ">900.00 </td><td style="text-align:right; ">30.00 </td><td style="text-align:right; ">0.00 </td><td style="text-align:right; ">30.00 </td><td style="text-align:right; ">960.00</td></tr></tbody></table> etc

Excel tables to the web >> Excel Jeanie HTML 4

 

[smm3]

All sounds good, but I don't even know where to start except manually. Could you start me off in the right direction?

I filtered Jan data to a new worksheet, but got stuck on how to get Feb's new people and amounts for new people as well as people who won in Jan with their amounts.
Vickie

 

[Dryver14]

send file to dryver14@yahoo.com