[Solved] Calc Macro to copy & paste cells

[boyurboy]

Hello, all!

I cannot for the life of me figure this out quickly enough, so any help is greatly appreciated.

I need to cut cell contents (including formatting) for the currently selected cell in one sheet (from a table that is 6x80 cells)
and paste it to the first empty row on a list (one column in a separate sheet). I suspect about 200 of the values in the first sheet will be selected and pasted to the list.

I want to bind the macro to do this to a simple button, that way the user can select a cell, hit the button, and be done. Any notions on how to build the macro? I am an absolute novice at this, and my attempts to implement on my own have been futile. Thanks in advance!

- B.

[Charlie Young]

My attached example is hardly the only way to do this, and maybe more complicated than necessary. My "table" on sheet one, that is, the valid cells for copying from, is A2:A37, I have included various formatting in the characters there. The destination column is Column A of Sheet2. Hopefully it will be easy to modify to your exact purpose, but don't be afraid to ask questions here.

[boyurboy]

Thanks for the help! I think this is solved!

[AndresAprende]

Thanks Charlie