Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 18th 05, 03:33 AM
scronk
 
Posts: n/a
Default 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


  #2   Report Post  
Old October 18th 05, 08:08 AM
Max
 
Posts: n/a
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
How do I get a list of data on one sheet into the form on the fir. PrestonL Excel Discussion (Misc queries) 0 February 16th 05 09:29 PM
pull data from sheet two, then fill in the data to sheet one (part Jim Excel Worksheet Functions 3 December 11th 04 04:51 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 09:15 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017