Hello,
I have 3 separate rows of information on one page of my workbook. they are each in a named range (as the cell location may move as I insert lines). I want to paste values for each of these rows to a location on my worksheet based on the user selecting 1-6 in a cell on the inputs page. e.g., if the user selects 1, it will be pated in the destination row, if the user selects 2 it goes in the row right under this, 3 it goes in the row 2 spots below.
Is there a way to do this simply in VBA, perhaps with some kind of relative reference to the initial paste row?
I have 3 separate rows of information on one page of my workbook. they are each in a named range (as the cell location may move as I insert lines). I want to paste values for each of these rows to a location on my worksheet based on the user selecting 1-6 in a cell on the inputs page. e.g., if the user selects 1, it will be pated in the destination row, if the user selects 2 it goes in the row right under this, 3 it goes in the row 2 spots below.
Is there a way to do this simply in VBA, perhaps with some kind of relative reference to the initial paste row?