Moving Rows on excel

Hi,

Please upload your workbook so that we can see the request in context. It will require a macro to do this.

Hi Dean,

You can add the following code to the workbook module. If you had named the worksheets identical to the values provided in the drop down box the code would have been much shorter and simpler, now a select case is needed to determine the name of the target worksheet.

Please Login or Register  to view this content.

Hi Dean,

The worksheet names still differ from the values provided in the drop down list, and the code provided by me is not present in the workbook module. What has happened?

Dean,

I have renamed the worksheets and have added the necessary code. Note that the "move" of the row only happens when the cursor leaves the cell after the value has been selected and not immediately when selecting the dropdown value

Hi Dea,

Please check post #7 as it already contains the revised workbook including the working code