Hello, I am really having problems finding a solution to the following. In my workbook I have two sheets "sheet1" and "sheet2". "Sheet1" contains a table of dynamic length, i.e. rows can be added. I want to copy some columns of that table into "Sheet2".

Sheet1

A | B | C | D | E |
line 1
line 2
....
line n


I want to copy the first three columns of sheet1 into sheet2, including all lines of the table
Sheet2
A | B | C |
line 1
line 2
....
line n

Is it possible to write a macro for that, which updates as soon as a cell is updated in sheet1, or just by placing a button on sheet1?

Thanks, Lily.