Transfer Values to Other Sheets

**basketball2524** · 12-19-2013, 11:02 PM

Does anybody know how to make a macro that will search for certain values in Column H. If the value is empty that entire row will go to the first available row in the Sheet named Delete. If the Value says Dupe that entire row will go to the first available row in the sheet named Dupe Sheet. If it says Import that entire row will go to the first available row in the sheet named Import. This macro will run until it find 3 cells in a row empty in Column B. Both of these criteria start in row 2.

**alansidman** · 12-19-2013, 11:58 PM

Easier to write if you provide a sample worksheet holding the data.

Questions: You use the term "go to the first available......" Does this mean the data should be copied to the particular sheet or cut and pasted to the particular sheet. If cut and pasted, do you want the empty row deleted? Will there be data below the three empty cells in column B or is this your way of saying that three empty cells means there is no further data?

**basketball2524** · 12-20-2013, 09:58 AM

It should be cut and pasted to the particular Sheet in the first available row on the new sheet. There will be other information already on those sheets that is why I would need it to find the first available row. This way it doesn't delete something already there. There wont be any data below the 3 empty cells in Column B its just my way of knowing the macro is complete. There might be some spaces between information in Column B that is why I'm having it look for 3. Thanks again for your help. Attached is a sample of the information before the macro runs. Test24.xlsx