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.
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.