Copy data from 1 sheet to another.

[apoorvagala]

Hi !
Please find my file in link attached. Excel 2007
http://www.freefilehosting.net/inv


I want to copy data from Data sheet to Edit sheet.
If user selects say invno 2 from the drop down list, I am able to reach to the first entry of invno 2 in column A of data sheet. Therefor my active cell would be A5 as per my sheet. I want to copy whole of the data i.e. A5:H5 and down till A12:H12 to Edit sheet A2 onwards. Here user will edit any data if he want to say qty or rate or date etc. but not the INVNo. The these data will be copied back to Data sheet. How to go about. My level is OK with macro.

Thanks,
Regards
Apoorva

 

[Trevor G]

You can use something like this, it might not be the smoothist but it works. When you adjust which number to look for in the code it runs fine. Sample of your sheets is shown below and the code I have created

Data

<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: 75px"><COL style="WIDTH: 131px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></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></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">INVNO</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">DATE</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">CUSTNAME</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">DNO</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">SIZE</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">QTY</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">RATE</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">AMT</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C318</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">L</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">695 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2,085 </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C318</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">XL</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">720 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2,160 </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C351</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">L</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">655 </TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1,965 </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C320</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">XL</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">520</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">520</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C334</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">615</TD><TD style="TEXT-ALIGN: right">2460</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C334</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">XL</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">640</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2560</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C345</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">L</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">595</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1785</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C345</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">620</TD><TD style="TEXT-ALIGN: right">2480</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C200</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right">575</TD><TD style="TEXT-ALIGN: right">575</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C200</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right">600</TD><TD style="TEXT-ALIGN: right">600</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C350</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: right">625</TD><TD style="TEXT-ALIGN: right">1250</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Dost Ind. Pvt. Ltd</TD><TD>C341</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">665</TD><TD style="TEXT-ALIGN: right">1995</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Dost Ind. Pvt. Ltd</TD><TD>C341</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">690</TD><TD style="TEXT-ALIGN: right">2070</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Dost Ind. Pvt. Ltd</TD><TD>C334</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">615</TD><TD style="TEXT-ALIGN: right">1230</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Dost Ind. Pvt. Ltd</TD><TD>C334</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">640</TD><TD style="TEXT-ALIGN: right">1280</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C345</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">595</TD><TD style="TEXT-ALIGN: right">1190</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C345</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">620</TD><TD style="TEXT-ALIGN: right">1240</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C330</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">595</TD><TD style="TEXT-ALIGN: right">1190</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C330</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">620</TD><TD style="TEXT-ALIGN: right">620</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C334</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">615</TD><TD style="TEXT-ALIGN: right">2460</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C334</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">640</TD><TD style="TEXT-ALIGN: right">2560</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">ABC Enterprise</TD><TD>C339</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">615</TD><TD style="TEXT-ALIGN: right">1845</TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>H2</TD><TD>=IF(ISBLANK(G2),"",F2*G2)</TD></TR><TR><TD>H3</TD><TD>=IF(ISBLANK(G3),"",F3*G3)</TD></TR><TR><TD>H4</TD><TD>=IF(ISBLANK(G4),"",F4*G4)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

After running the code the second sheet looks like this

Edit

<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: 80px"><COL style="WIDTH: 75px"><COL style="WIDTH: 128px"><COL style="WIDTH: 67px"><COL style="WIDTH: 67px"><COL style="WIDTH: 65px"><COL style="WIDTH: 73px"><COL style="WIDTH: 67px"></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></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">INVNO</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">DATE</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">CUSTNAME</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">DNO</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">SIZE</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">QTY</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">RATE</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; TEXT-DECORATION: underline">AMT</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C320</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">XL</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">520</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">520</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C334</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">615</TD><TD style="TEXT-ALIGN: right">2460</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C334</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">XL</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">4</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">640</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">2560</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">C345</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">L</TD><TD style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 10pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">595</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Arial; FONT-SIZE: 10pt">1785</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C345</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">620</TD><TD style="TEXT-ALIGN: right">2480</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C200</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right">575</TD><TD style="TEXT-ALIGN: right">575</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C200</TD><TD style="TEXT-ALIGN: right">XL</TD><TD style="TEXT-ALIGN: center">1</TD><TD style="TEXT-ALIGN: right">600</TD><TD style="TEXT-ALIGN: right">600</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">13/05/2011</TD><TD style="FONT-FAMILY: Arial; FONT-SIZE: 10pt">Altamount Industries</TD><TD>C350</TD><TD style="TEXT-ALIGN: right">L</TD><TD style="TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: right">625</TD><TD style="TEXT-ALIGN: right">1250</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4

The code I used is as follows:

Sub copyRegion()

Dim R As Range
Selection.AutoFilter
ActiveSheet.Range("$A$1:$H$500").AutoFilter Field:=1, Criteria1:="2"
With ActiveCell.CurrentRegion
Set R = Range(.Cells(2, 1), .Cells(.Cells.Count))
End With
R.Copy
Sheets("Edit").Select
Range("A1").Activate
Do Until ActiveCell.Value = ""
ActiveCell.Offset(1, 0).Select
Loop
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub