I need help with an excel macro that will copy the contents of a range
to a single column of rows.

Scenario:
user selects continuous range R
user executes the macro
user is prompted to select a cell C
If C is included in R user is prompted to select a non-inclusive cell
Data from R is copied, left-to-right, top-to-bottom to destination
cells starting at C

Example. Assuming one char/cell

a b
c d

is copied as

a <- selected cell C
b
c
d

could you please help? TIA