p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   Search criteria, create new worksheet (http://p2p.wrox.com/showthread.php?t=9982)

Wire March 2nd, 2004 12:51 PM

Search criteria, create new worksheet
 
I just want to know if this is possible:

I want to compare a certain column in a worksheet against 15 search criteria. If any row contains a column that matches one of the criteria, I want that row taken out and put into a new worksheet. The first row that matches should create the new worksheet, and any additional matching rows should be added to it.

Thanks.

Deepesh_Jain March 3rd, 2004 01:37 AM

Yes this is possible through the VBA programming in Excel. You can use the Excel object to complete the same task.

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

Wire March 4th, 2004 11:12 PM

What do you mean by Excel object? I've done some programming in the past (5 years ago), but I've never done any work with VBA. I don't even know how to execute the program from within Excel. I have an idea on what layout I want to use but I don't know any of the VBA syntax.


Wire March 6th, 2004 10:56 AM

I got it working.



All times are GMT -4. The time now is 05:33 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.