Salmons41578
New Member
- Joined
- Jul 25, 2013
- Messages
- 2
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:
[TABLE="width: 652"]
<TBODY>[TR]
[TD]COUNTRY TOTAL</SPAN>
[/TD]
[TD="align: right"]Jun-12</SPAN>
[/TD]
[TD="align: right"]Jul-12</SPAN>
[/TD]
[TD="align: right"]Aug-12</SPAN>
[/TD]
[TD="align: right"]Sep-12</SPAN>
[/TD]
[TD="align: right"]Oct-12</SPAN>
[/TD]
[TD="align: right"]Nov-12</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 150mg BID bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 100mg BID bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 75mg BID bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of 150mg BID PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 100mg BID PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 75mg BID PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of 2mg QD bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1.5mg QD bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1mg QD bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of 2mg PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1.5mg PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1mg PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
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!
[TABLE="width: 535"]
<TBODY>[TR]
[TD][/TD]
[TD]Jul-13</SPAN>
[/TD]
[TD]Aug-13</SPAN>
[/TD]
[TD]Sep-13</SPAN>
[/TD]
[TD]Oct-13</SPAN>
[/TD]
[TD]Nov-13</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 150mg BID bottles</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Australia</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]24</SPAN>
[/TD]
[TD]22</SPAN>
[/TD]
[/TR]
[TR]
[TD]Austria</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Belgium</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Czech_Republic</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Denmark</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Finland</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]France</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[TD]26</SPAN>
[/TD]
[TD]23</SPAN>
[/TD]
[TD]20</SPAN>
[/TD]
[TD]17</SPAN>
[/TD]
[/TR]
[TR]
[TD]Germany</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]37</SPAN>
[/TD]
[TD]34</SPAN>
[/TD]
[TD]31</SPAN>
[/TD]
[/TR]
[TR]
[TD]Greece</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]6</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
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:
[TABLE="width: 652"]
<TBODY>[TR]
[TD]COUNTRY TOTAL</SPAN>
[/TD]
[TD="align: right"]Jun-12</SPAN>
[/TD]
[TD="align: right"]Jul-12</SPAN>
[/TD]
[TD="align: right"]Aug-12</SPAN>
[/TD]
[TD="align: right"]Sep-12</SPAN>
[/TD]
[TD="align: right"]Oct-12</SPAN>
[/TD]
[TD="align: right"]Nov-12</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 150mg BID bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 100mg BID bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 75mg BID bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of 150mg BID PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 100mg BID PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 75mg BID PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of 2mg QD bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1.5mg QD bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1mg QD bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of 2mg PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1.5mg PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 1mg PTM bottles</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
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!
[TABLE="width: 535"]
<TBODY>[TR]
[TD][/TD]
[TD]Jul-13</SPAN>
[/TD]
[TD]Aug-13</SPAN>
[/TD]
[TD]Sep-13</SPAN>
[/TD]
[TD]Oct-13</SPAN>
[/TD]
[TD]Nov-13</SPAN>
[/TD]
[/TR]
[TR]
[TD]Number of 150mg BID bottles</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Australia</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]24</SPAN>
[/TD]
[TD]22</SPAN>
[/TD]
[/TR]
[TR]
[TD]Austria</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Belgium</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Czech_Republic</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Denmark</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Finland</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]France</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[TD]26</SPAN>
[/TD]
[TD]23</SPAN>
[/TD]
[TD]20</SPAN>
[/TD]
[TD]17</SPAN>
[/TD]
[/TR]
[TR]
[TD]Germany</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]37</SPAN>
[/TD]
[TD]34</SPAN>
[/TD]
[TD]31</SPAN>
[/TD]
[/TR]
[TR]
[TD]Greece</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]6</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]