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

[Carlo]

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?

[Ron de Bruin]

Hi Carlo

Like a database ?

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



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



"Carlo" <[email protected]> wrote in message news:[email protected]...
> 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?

[Tom Ogilvy]

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

might be what you want.

--
Regards,
Tom Ogilvy

"Carlo" <[email protected]> wrote in message
news:[email protected]...
> 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?

[Alex]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>