Hi I need to create a macro to input a formula that displays the current cell in the next sheet, a few cells along. I need a popup box to come up how many columns along the cell should be displayed in on the other sheet. I have attached a workbook with the blank display Sales Order Value sample.xlsx. Please Help Me.

Thanks,
Jamie