Hi All
I have a problem, which I'm sure one of you out there can help me with .
I have my workbook with 4 sheets, which consist of one typing-sheet and 3 backup sheets.
The macro I need should do the following process, when I run it:
- Copy all the rows from the typing sheet “Typing” where the cells in column N is = “Vundet” into the next empty row in the sheet “Vundet” and then clear the copied rows from the typing sheet “Typing”.
- Copy all the rows from the typing sheet “Typing” where the cells in column N is = “Tabt” into the next empty row in the sheet “Tabt” and then clear the copied rows from the typing sheet “Typing”.
- Copy all the rows from the typing sheet “Typing” where the cells in column N is = “Fravalgt” into the next empty row in the sheet “Fravalgt” and then clear the copied rows from the typing sheet “Typing”.
- If the cells in column N is empty = do nothing.
An example in the attached file:
Row 7, 9 and 10 should be copied into the sheet “Vundet”, and the rows should be cleared in the typing sheet.
Row 8, 11 and 12 should be copied into the sheet “Tabt” and the rows should be cleared in the typing sheet.
Row 13, 14 and 15 should be copied into the sheet “Fravalgt” and the rows should be cleared in the typing sheet.
Sample1.xlsx
Sincerely regards
Jens/Valemaar
Bookmarks