Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

copy an entire row IF a statement is true

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
colettey29 - 15 Jun 2007 18:40 GMT
The first worksheet in my spreadsheet contains all of the data that I've
entered.  I would like to create additional tabs that pull specific bits of
data out -- based upon inidivudal columns in the first spreadsheet (role
group, event name, etc.)  Is there any easy way to do this?
Ron de Bruin - 15 Jun 2007 18:43 GMT
Hi colettey29

Try the first example on this page that use AutoFilter
http://www.rondebruin.nl/copy5.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> The first worksheet in my spreadsheet contains all of the data that I've
> entered.  I would like to create additional tabs that pull specific bits of
> data out -- based upon inidivudal columns in the first spreadsheet (role
> group, event name, etc.)  Is there any easy way to do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.