Locating and selecting Data from Worksheet

J

Jason K

Can someone help me... I want to locate and select specific data based on
certain criteria. For example I want to locate certain plans that are either
outside or within a date range.
in one column is the plan and in another the date, need to select the entire
row

And after locating the rows that have these plans, cut and move them to
another location.

Thank You
 
J

Jason K

A B C D E F G
POLICY CLAIM PLAN EFF DTE xxxx xxxx xxxx
HL01231 6248000 4NZDF1 1/26/1987 xxxx xxxx xxxx
HL01317 8203028 41ZLF1 10/15/1991 xxxx xxxx xxxx

I need to locate diferent plans with the eff date outside a certain range,
and move those entire rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look up within date range 2
Locating Formulas within a Worksheet 5
Mouse selecting unwanted data 2
Opening a Word Merge and Selecting Its Data Source from Access 3
Restrictions on worksheet display 3
Selecting rows. 3
locating and deleting duplicate cell entries 2
Excel Error Help 1

Top