Excel Question: how to create a button to copy a data each cell

HIROYUKI TAMURA
HIROYUKI TAMURA used Ask the Experts™
on
I would like to create a button on Excel which copy a content of cell data. each click moves down next cell on row and copy again.
Please advise.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Rob HensonFinance Analyst

Commented:
And what should it do with each of the copied cell contents? Each time you copy, the clipboard where the copy is stored temporarily will be overwritten.

Some more details required, a sample file with before and after examples would be good.

Author

Commented:
Thank you, Rob.
Here is sample.
After clicking, it copy C3 and move down to C4.

Snap420.pngEE_Sample20191218.xlsx
Rob HensonFinance Analyst

Commented:
Copy C3 and do what with it before moving to C4
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
If you only want to copy the active cell to the clipboard and move one cell down, you may try something like this...

Sub CopyCell()
Selection.Copy
Selection.Offset(1).Select
End Sub

Open in new window

EE_Sample20191218.xlsm

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial