Use a button to create a table in excel without overwriting cells
 

Is there any chance that I can set up a macro button - that take some values
and put them in a table. Without overwriting the same cells over and over?

Use a button to create a table in excel without overwriting cells
 

Hi Carlo

Like a database ?

See
http://www.rondebruin.nl/copy1.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Carlo" wrote in message ...
Is there any chance that I can set up a macro button - that take some values
and put them in a table. Without overwriting the same cells over and over?

Use a button to create a table in excel without overwriting cells
 

Range("A1:A10").copy Destination:=Worksheets( _
"Sheet2").Cells(rows.count,1).End(xlup)(2)

might be what you want.

--
Regards,
Tom Ogilvy

"Carlo" wrote in message
...
Is there any chance that I can set up a macro button - that take some
values
and put them in a table. Without overwriting the same cells over and over?

Use a button to create a table in excel without overwriting ce
 

Hi
can you help me too
what if i want to paste the values in coloumn and not into rows?

"Tom Ogilvy" wrote:

Range("A1:A10").copy Destination:=Worksheets( _
"Sheet2").Cells(rows.count,1).End(xlup)(2)

might be what you want.

--
Regards,
Tom Ogilvy

"Carlo" wrote in message
...
Is there any chance that I can set up a macro button - that take some
values
and put them in a table. Without overwriting the same cells over and over?