Data Summary worksheet help!!

[Salmons41578]

Hello All,

I am hoping that this forum will be able to help me out. I have data across multiple worksheets (named as different countries) all with the same format as below:

COUNTRY TOTAL</SPAN>	Jun-12</SPAN>	Jul-12</SPAN>	Aug-12</SPAN>	Sep-12</SPAN>	Oct-12</SPAN>	Nov-12</SPAN>
Number of 150mg BID bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 100mg BID bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 75mg BID bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 150mg BID PTM bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 100mg BID PTM bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 75mg BID PTM bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 2mg QD bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 1.5mg QD bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 1mg QD bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 2mg PTM bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 1.5mg PTM bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>
Number of 1mg PTM bottles</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>

<TBODY>
</TBODY>

I would like to have a summary sheet that lists out all the data as shown below for each bottle type. Is there an easy quick way to do this or do I need to copy and paste each row into the summary page?

Thank you so much for any help you can provide!

	Jul-13</SPAN>	Aug-13</SPAN>	Sep-13</SPAN>	Oct-13</SPAN>	Nov-13</SPAN>
Number of 150mg BID bottles</SPAN>
Australia</SPAN>	18</SPAN>	18</SPAN>	18</SPAN>	24</SPAN>	22</SPAN>
Austria</SPAN>	1</SPAN>
Belgium</SPAN>	3</SPAN>
Czech_Republic</SPAN>	3</SPAN>
Denmark</SPAN>	3</SPAN>
Finland</SPAN>	0</SPAN>
France</SPAN>	9</SPAN>	26</SPAN>	23</SPAN>	20</SPAN>	17</SPAN>
Germany</SPAN>	18</SPAN>	40</SPAN>	37</SPAN>	34</SPAN>	31</SPAN>
Greece</SPAN>	1</SPAN>	7</SPAN>	6</SPAN>	5</SPAN>	5</SPAN>

<TBODY>
</TBODY>

 

[sdsurzh]

hi,
can you please mail the sample workbook. sdsurzh@gmail. com

SK

 

[sdsurzh]

Hi Mathew,

I have mailed you the workbook please check and let me know your feedback.

Thanks,
SK

 

[Salmons41578]

Hi Mathew,

I have mailed you the workbook please check and let me know your feedback.

Thanks,
SK

SK,

Thank you so much for your help! It worked perfectly, simply amazing!

Kindest Regards,

Matt

 

[sdsurzh]

Hi Maathew,

Good to hear from you. Glad to help you.

Thanks,
SK

 

[abrock]

Can y'all share the solution? I could definitely use that!