PC Review


Reply
Thread Tools Rate Thread

Copy Rows to New Sheet based on User Selection in Drop-down List

 
 
=?Utf-8?B?Q2FybGVl?=
Guest
Posts: n/a
 
      2nd Apr 2007
I posted something similar, but wasn't at all clear. This is what i am
trying to do.

I want to place a drop-down select box on Sheet 3 with values 1-12,
representing months of the year. I want the user to be able to select a
month value from the drop-down select box. Once the value is selected, i
want Excel to search column B on Sheet 1, looking for all date values
matching the month selected by the user. I then want Excel to copy the
identified rows in Sheet 1, including column headers, to Sheet 2, replacing
anything that was there previously.

Can anyone help me out with this?
--
Carlee
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy rows from one Data sheet to another sheet based on cell conte John McKeon Microsoft Excel Misc 2 15th May 2010 06:49 AM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet. bertbarndoor Microsoft Excel Programming 4 5th Oct 2007 04:00 PM
Based on Drop-Down Selection go to that Section on Sheet =?Utf-8?B?R29sb3Zh?= Microsoft Excel Misc 3 17th Apr 2007 07:26 PM
Copy row data based on drop down list selection Tom Microsoft Excel Programming 0 22nd Aug 2006 04:51 AM
Hide rows based on selection in drop down list.... Sean Goldsworthy Microsoft Excel Misc 0 26th Aug 2004 02:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:47 PM.