Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prompt to update worksheets (excel 97)

    <img src=/S/brainwash.gif border=0 alt=brainwash width=15 height=15> I would first like to thank all of you here at woodys lounge for making my internship a lot easier.

    My newest obstacle is this. I have a file that currently allows the user to enter a project name and then assigns it a unique ID# and allows them to insert that ID# in a spreadsheet that serves as a work calender. The ID# is then translated into another worksheet form the ID# format to the actual project name they originally gave it. However many weeks the project will take in each quarter, and total of the year is also calculated by excel.

    That all works fine but my new problem is that after a project name is entered, and the duration is entered into the calender, and the totals for each quarter are calculated I need to send this to a more detailed worksheet.

    I have 4 other worksheets (US,ASIA,UK,EUR). Then within each worksheet is a column for a division (Finance,Tech,Cearing etc.). Subs in each column is a more detailed title for each division. I need the user to be able to select which worksheet, division, and exact sub-unit that the new project will affect. This way the duration for the quarters can be added to this more detailed sheet.

    I am thinking that a series of 3 list boxes will be the best approach. The user just narrows the field after each list box selection. But how do i tell xls to add this project there and whatnot????

    If you need more info I'll be checking this post every 3 minutes so I'll get right back to you. Thanks in advance.

    If this requires VBA could you please explain where i enter the coding and where to enter my file and worksheet names. I always mess some syntax up and get stuck forever, thanks alot.

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prompt to update worksheets (excel 97)

    Me thinks you might have to post some of your current workbook so it can be seen exactly what you are trying to do...

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prompt to update worksheets (excel 97)

    Here is my file, the FYI sheet has all the info you'll need. Thanks
    Attached Files Attached Files

Posting Permissions

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