+ Reply to Thread
Results 1 to 15 of 15

Create Excel Report Sheet with VB Button

Hybrid View

JimmiOO Create Excel Report Sheet... 01-22-2009, 10:39 AM
JimmiOO Any help greatly appreciated 01-22-2009, 12:43 PM
JimmiOO Can anyone help with this? 01-22-2009, 08:07 PM
royUK It would be much simpler to... 01-23-2009, 03:30 AM
JimmiOO Hi Roy thanks for that, any... 01-23-2009, 04:44 AM
JimmiOO Hi Roy I have changed the... 01-23-2009, 09:30 AM
StephenR Needless to say, you would be... 01-23-2009, 10:12 AM
JimmiOO Hi Stephen i have now... 01-23-2009, 10:19 AM
StephenR That's better but not quite... 01-23-2009, 10:35 AM
JimmiOO Hi Stephen i would prefer to... 01-23-2009, 10:51 AM
StephenR Try this: Sub... 01-23-2009, 10:59 AM
JimmiOO Thanks for the code Stephen,... 01-23-2009, 11:35 AM
StephenR You already have the Click... 01-23-2009, 11:43 AM
JimmiOO Ah brillian Stephen it works... 01-23-2009, 11:54 AM
StephenR My pleasure, glad it worked. 01-23-2009, 11:59 AM
  1. 01-23-2009, 04:44 AM #1
    JimmiOO is offline
    Forum Contributor
    Join Date
    07-07-2008
    Location
    sCOTLAND
    MS-Off Ver
    Office 2003 SP3
    Posts
    256
    Hi Roy thanks for that, any chance someone could help in sorting this out for me? i don't have a lot of knowledge with VB.
    Last edited by JimmiOO; 01-23-2009 at 09:01 AM.
    Reply With QuoteRegister To Reply
  2. 01-23-2009, 09:30 AM #2
    JimmiOO is offline
    Forum Contributor
    Join Date
    07-07-2008
    Location
    sCOTLAND
    MS-Off Ver
    Office 2003 SP3
    Posts
    256
    Hi Roy

    I have changed the sheets now so that the job number is in column A on both the Job Info and Jobs Done info sheets. I have aslo added a VB button onto the intro page that goes to the outstanding job sheet. I have also added an Outstanding Job sheet with the same format as the Job Info sheet.

    Phew

    Could anyone help me out with a code i can apply to the Outstanding Job VB button that will look at the Job Number in column A in both Job info and job done info sheets and then list all the outstanding jobs that have not yet been done?

    Is this possible?
    Reply With QuoteRegister To Reply
  3. 01-23-2009, 10:12 AM #3
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    Needless to say, you would be much better off if you heeded Roy's advice. It would make life a lot simpler. In any case your attachment does not reflect your updates.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1