Macro Needed - Capture data from one worksheet to another

[skultety]

Hi ExcelForum,

I have two worksheets. The rows in Sheet 1 are populated daily (columns A; I-M). Sheet 2 would be an archive of these daily entries.

I'm interested in a macro (w/ button) that captures the rows from Sheet 1 into the first empty rows of Sheet 2. A timestamp for the capture (in Sheet 2) would also be great.

For clarity: Sheet 1, Column A, Row 10 would copy to Sheet 2, Column B, Row 10
Sheet 1, Column I, Row 10 would copy to Sheet 2, Column C, Row 10
.........................................
Sheet 1, Column M, Row 10 would copy to Sheet 2, Column G, Row 10

Timestamps would be in Column A row 10.

Thanks in advance,

Will


Thanks in advance,

Will

[JBeaucaire]

Try this....