VB button code to report on Excel sheet

[JimmiOO]

Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Could someone please help me with this?
<o> </o>
I have an excel workbook with various worksheets, Intro, Job Info, Jobs Done Info & Jobs Outstanding. On the Job Info and Jobs Done Info I have a unique job number in column A. I am looking for a code I could apply to a VB button in the Intro page that would look at both the Job Info & Jobs Done Info pages compare the unique job numbers on both sheets and then list all the outstanding jobs in the outstanding job sheet.
<o> </o>
Phew I hope I have explained this ok. Is this possible?

 

[stanleydgromjr]

JimmiOO,

Welcome to the MrExcel board.

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml

Instructions for using "Colo's HTML Maker":
http://www.mrexcel.com/forum/showthread.php?t=89356


Or, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/index.php?f=1

Instructions for using "Excel Jeanie HTML 4":
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Have a great day,
Stan

 

[JimmiOO]

Ok here is the screen shots, as explained in my first post, when i click on my outstanding jobs button i want it to look at the Job Info sheet and the jobs done sheet match up the job numbers in column A then list all the jobs that are outstanding in the outstanding job sheet.

Any help would be great

Thanks for the welcome to the forum.

 

[stanleydgromjr]

JimmiOO,

Thanks for the graphics, but to assist you we will need screenshots (with live or sample data) created with either of the following two addins.


Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml

Instructions for using "Colo's HTML Maker":
http://www.mrexcel.com/forum/showthread.php?t=89356


Or, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/index.php?f=1

Instructions for using "Excel Jeanie HTML 4":
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Have a great day,
Stan

 

[JimmiOO]

Is it possible just to upload the sheet? If not i will have to do it latter when i get home.