copy rows based on 1 criteria + user input + pastevalues (almost there...)

This will not only demonstrate how to do a PasteSpecial into the next empty row on Sheet2, it will show you how to use the autofilter to apply your criteria to the entire dataset at once and copy all matching rows at one time, you don't have to loop through one row at a time testing.

Please Login or Register  to view this content.

Many thanks for the quick reply JBeaucaire, unfortunately it doesn't work...it always says that there where no matches.

I tried to delete the inputbox criteria to see if I could understand the error and it started to work but only copying the cells in column A. I changed a little more the code and it started to copy almost all cells, the problem is that it can't paste empty cells.

Please Login or Register  to view this content.

Also this is without the string verification. I will try to understand all the code that you used to see if I find a solution.

EDIT: I edited the line:
.Range("A3:AB" & LR).Copy -> Since AB is the last column with data.

EDIT2:tried to add an attachment but no joy... (xlsm < 30kb)

I'll be happy to test this on a sample workbook if you'd care to upload one with the names desensitized.

Yeah, I see a few things.

1) Be sure to read through the code carefully until it's clear what each line of code is doing.

2) The macro isn't copying headers, so copy your row1 headers onto Sheet2 so they're there permanently.

3) After you've done that, one assumes you want sheet2 "reset" each time you use it, so I added a line of code to clear rows2 downward.

4) Your data starts on row2 of the example sheet, but your macro in Post#1 implied the data started in row3. I've edited the macro to apply the Autofilter into the headers in row1 instead of row2. Autofilter has to be in the row directly above the data.

5) I've changed your LSearchValue variable so that is specifically a Date value in the declarations. Then we're going to use a range filter again to show any date value on that day.

Please Login or Register  to view this content.