| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I not overwriting non blank destination cells ? | Excel Discussion (Misc queries) | |||
| Overwriting cells | Excel Discussion (Misc queries) | |||
| Create a button to Clear Cells | Excel Discussion (Misc queries) | |||
| Overwriting Cells | Excel Discussion (Misc queries) | |||
| How do you create a macros without overwriting the previous one y. | Excel Discussion (Misc queries) | |||
Linear Mode
