Moving rows to other sheets

  • Thread starter Thread starter Edwin Villamayor
  • Start date Start date
E

Edwin Villamayor

I was wondering if anyone could be of assistance with my dilemma. I
want to run a macro that does the following:

Sheet 1 has records with column headers such as name, address, and
date. If the date field is populated with a date, I want to take the
entire row and move it to Sheet 2, then delete the source row in Sheet
1. However, if the date field is populated by a word such as "Dead
Deal" I want to take the entire row and move it to Sheet 3, then
delete the source row in Sheet 1.

Thanks in advance.

Edwin
 
Assuming you are only looking for a way to distingush between the two
records you can use the ISTEXT function to test for which type of
record you have. Dates are numbers so if your date field is in col A
and you are on the record at line 12 you can use the ISTEXT() function
to determine how to move the record.

I am assuming that you know how to step through the records and select
a new free line in your target sheets.
 
Back
Top