VB button code to report on Excel sheet

J

JimmiOO

Board Regular
Joined
Jan 23, 2009
Messages
51
Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
Could someone please help me with this?
<o:p> </o:p>
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:p> </o:p>
Phew I hope I have explained this ok. Is this possible?
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Sort by date Sort by votes
Upvote 0
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.

intronc4.jpg


jobdoneinfokw2.jpg


jobinfobr9.jpg


outstandingjobstq7.jpg
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Button to scroll from previous or next row of data from table
Replies
7
Views
537
brianv
B
L
  • Question Question
Printing to Zebra label printer
Replies
2
Views
450
Jeffrey Mahoney
Jeffrey Mahoney
W
  • Question Question
Creating a 'Reset' button for a text form, plus additional buttons
Replies
2
Views
463
WEB78
W
B
  • Solved
vba code to give next Sunday date for pasted data
Replies
2
Views
796
bh24524
B
I
  • Question Question
Value not shown in ComboBox1 when code run
Replies
1
Views
94
ipbr21054
I

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top