Hello again!
I've attached a copy of my file.
What i have on sheet one is data for jobs i'm working on (all fake data of course).
What i want to be able to do is sort data from the first sheet, onto the other sheets using the "Job Status" letter code.
So, if the Job Status code is "R" next to a job then id like the entire row to display in the second sheet (the received sheet). And i need for it to copy all of the jobs with an "R" code. The same with "I" for the inspected sheet.
The PA0#### is the job number and id need these to stay in descending order as they are on the first sheet.
Id appreciate any help anyone can give me! And maybe if there's any ideas for making the files size smaller!
Thank you!
Mark J.PA List TEST.xlsx
Bookmarks