![]() |
Moved data to new sheet based on list selection
I am trying to move an entire row to a new sheet in the same workbook once a specific list item is selected. Example: Cell in row on sheet 1 has 4 items to select in a pull down menu list, once number 4 is selected, I want the whole row moved to the next available row in sheet 2. Any ideas? Scott -- scronk ------------------------------------------------------------------------ scronk's Profile: http://www.excelforum.com/member.php...o&userid=28175 View this thread: http://www.excelforum.com/showthread...hreadid=477027 |
Moved data to new sheet based on list selection
Try browse this recent thread (similar query)
with responses for 2 approaches: http://tinyurl.com/ddo6m -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "scronk" wrote in message ... I am trying to move an entire row to a new sheet in the same workbook once a specific list item is selected. Example: Cell in row on sheet 1 has 4 items to select in a pull down menu list, once number 4 is selected, I want the whole row moved to the next available row in sheet 2. Any ideas? Scott -- scronk ------------------------------------------------------------------------ scronk's Profile: http://www.excelforum.com/member.php...o&userid=28175 View this thread: http://www.excelforum.com/showthread...hreadid=477027 |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com