Excel VBA - Rows Getting Deleted on running macros.

Hi All,
I have earlier created a job tracking sheet which was fine but was very big horizontally.
Was having difficulties while taking printouts etc. Hence I have been advised to changed.
To accommodate the report in an A4 paper, I have prepare the job in multiple lines (two
lines.). Created two macros - when Column K is having 100%, then the first line of the job
will be moved to next sheet on button click and when Column K is having "OK", the second
line will be moved to the next sheet relevant columns on button click.

The macros are running fine. However, after execution of the macros, the rows from top
are getting deleted. I request your help to get the same corrected.

Attached herewith the file.

Kindly help.

Possibly...

Please Login or Register  to view this content.

Thanks a lot dangelor.. its working fine now.

Glad I could help!

Hi Dangelor... Even though the initial problem of rows getting deleted has been
solved, I am facing another issue.

The Filtration criterial "OK" is considering only the first rows (Row No.5 and 6).
Consider job of rows 5 & 6 is pending, but job of rows 7 & 8 is finished, the
macro is not working.

Please guide suitably.