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

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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
432
brianv
B
W
  • Question Question
Creating a 'Reset' button for a text form, plus additional buttons
Replies
2
Views
150
WEB78
W
B
  • Solved
vba code to give next Sunday date for pasted data
Replies
2
Views
614
bh24524
B
I
  • Question Question
Value not shown in ComboBox1 when code run
Replies
1
Views
36
ipbr21054
I
I
  • Question Question
Receive Automation error when running code & values added to sheet twice
2
Replies
13
Views
420
NoSparks
N

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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