copy if

G

Guest

Hi,

I have a workbook where I want to copy data from one sheet to another sheet
based on a columns criteria.

If Worksheet_1, column A has the value 13-2006, I want all the rows that
contain this value to populate the empty Worksheet_2.

How do I write the if statement to make this happen?

Thanks.
 
G

Guest

Hey All,
I'm looking for the same type of formula, that if a vaue in a column meets a
certain criteria, it will copy the entire row into another sheet.
 
G

Guest

Hi,

I believe that it is the VLOOKUP function that is part of the equation. I
just cannot figure out how to incorporate it with copying those records that
meet criteria to a specified worksheet.
 

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

vlookup to another worksheet 3
conditional programming 1
"Undo" in Excel 2007 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Referencing a Range of Cells 3
2 formulas needed same workbook 15
Creating a dynamic IF statement 2
If statement to copy an entire row to other worksheet w/ in same b 7

Top