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.
Bookmarks