Copy rows with specific text in specific column into specific sheet

Maybe:

Please Login or Register  to view this content.

Yes. Just place it in a standard module and run.

It does not work quite as intended. Nothing happens when I run it .

Check after row 404 on each sheet. Typing should be cleared.

Ohhh nice work!!!

However, the values ​​can not be inserted into the first empty row after row 6 instead of row 404?

Also, is it possible that the formatting from the typing sheet is not cleared from the typing sheet?

Great job !!

Also the macro should do nothing with the row if the cell in column N is empty or have any other text og number. I can see that the macro fails if I'm writing anything but; "Vundet", "Tabt", or "Fravalgt" column N.

Try:

Please Login or Register  to view this content.

Yes, now the formatting in the typing sheet is staying untouched = Perfect!

But there is still two problems:
1. The copied rows should be inserted into the first empty row after row 6 instead of row 404.
2. If the cell in column N not contain the word "Vundet", "Tabt" or "Fravalgt" the macro should skip that row (do nothing).

In the attachment you see that the macro is failing .

Sample1.xlsm

/Valemaar

Try:

Please Login or Register  to view this content.

Yes now there the second problem left .

2. If the cell in column N not contain the word "Vundet", "Tabt" or "Fravalgt" the macro should skip that row (do nothing).

/Jens

Ok try:

Please Login or Register  to view this content.

Now we are almost there . But the I can see that the copied rows are not put into the next empty row on the backup sheets.

An example: If row 7, 8, 9 in the sheets "Vundet", "Tabt" or "Fravalgt" already have values in them, the macro overwrites these rows, instead of placeing the copied rows into the next empty row. In this example it would mean the macro should place the copied rows in row 10 and forward.


But you are doing a hell of god job


/Valemaar

Try:

Please Login or Register  to view this content.

Sorry to say it, but It still overwrites the data that is already in the 3 backup sheets when it paste the copied values. If it helps you could mayby program it to look at column A, and look for the first empty cell there?

Example:
Is Cell "A7" empty = no = Look in Cell "A8"
Is Cell "A8" empty = no = Look in Cell "A9"
Is Cell "A9" empty = no = Look in Cell "A10"
Is Cell "A10" empty = no = Look in Cell "A11"
Is Cell "A11" empty = YES = insert the copied rows in row 11 and down


/Valemaar

Unfortunately that's what the code tells it too do. However, the formatting on your spreadsheet for some reason makes it difficult to address those concerns. I've attempted to get around it but can't. Sorry I can't help you further.

Okay.. Would it help if I removed the formatting on the backup sheets or is it the formatting on the Typing sheet that is the problem?

Maybe I can get this code to work insted:

Please Login or Register  to view this content.

But then you can maybe help me by showing how I get the code to clear the values after they have been copied into the backup sheets?

/Jens