Excel VBA help required for moving content from one excel sheet to another.

**rachelsmith** · 10-26-2012, 07:18 AM

Hey,

I am new to Excel VBA. I have a problem as below:

I need to copy data from one excel sheet to another based on certain conditions.
If the values in each column match a particular criteria, I need to move it to another sheet.
For example,column 1 can have values A B C D and E and if the value in column 1=A or B, I need to move those entries to another sheet.
This way I have to check each column and move the entries which meet the criteria to another sheet.

Could somebody please help me?

**AB33** · 10-26-2012, 07:22 AM

Rachel,
It would be easier if you could attach a sample workbook with a desired result.

**JosephP** · 10-26-2012, 07:22 AM

please also note rule 8 on cross-posting and add the appropriate links to your first post. thanks :-)

**rachelsmith** · 10-26-2012, 09:56 AM

User Name Database Id
ABC 1 11
DEF 2 12
GHI 3 13
JKL 4 14
MNO 5 15

My requiremnt is to filter (in the order specified) the databases 1 and 3, then user CDE and JKL, then IDs 12 and 15 and then move them to another sheet (the whole row corresponding to that particular cell value). The rest of the entries should be present in the original sheet.