Running a report

[lucas1787]

Hi everyone, I hope someone can help with this.
I have a report a run every day that I then import in to excel.The columns I have are Job Number,Type,Account,Date,Customer,Reg,Labour,Parts and Sub.
Every day as I receive the job cards from the workshop and I then highlight in yellow them in the column "Job Number" to show I have them.
The next day I run the same report,which can have some of the job numbers missing as they would of been invoiced,so I use the new report but I then have to manually check the previous days report for the highlight jobs and manually highlight them on the new report.
Is there anything in excel that can transfer the highlight jobs on the day befores report to the new report if they are on there, to save me having to do this manually?.
Below is an example of the report. Thanks in advance Dave

example.JPG

[cbatrody]

Hi,

You can run a VLOOKUP and compare the 2 sheets for Job Number columns, insert a filter and segregate the matches.

[lucas1787]

Hi, could you point me in the right direction on how to set this up please?.Thanks dave

[cbatrody]

Hi Dave,

Please upload a sample template of your workbook here using "Go Advanced" option.