ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Moved data to new sheet based on list selection (https://www.excelbanter.com/excel-worksheet-functions/50946-moved-data-new-sheet-based-list-selection.html)

scronk

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


Max

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