Hi,

I have a column of values of finance data. ColumnB with 10 values

Col B
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100

User is prompted to select a row of these 10 rows (using Inputbox option).
Suppose user selects row#5 with $50 value.

How should I copy the values UPTO row#5 of Column B and paste in Column C
without hardcoding?

How should I copy the values AFTER row#5 UPTO row# 10 of Column B and paste
in Column D, STARTING FROM ROW 6 without hardcoding?

Required output

ColB ColC ColD
$10 $10
$20 $20
$30 $30
$40 $40
$50 $50 $50
$60 $60
$70 $70
$80 $80
$90 $90
$100 $100