Dear forum, I am new to this and this is my first post.
I have attached a file of dummy data to explain what I am trying to do.
I am the owner of a shared spreadsheet on a network drive accessed by approximately 160 project managers (PM), the majority of whom manage more than 1 project. The spreadsheet has 5 columns of data:
Project Manager Name
Project Number
Project Name
Forecast Spend
Costs to Date
I am attempting to create a userform that will be invoked automatically on file open, wherein the PM will find his/her name in a drop down box (populated from column A). This then needs to populate a second dropdown box with only those Project Numbers that are managed by that PM (column B). I have added Project Name to the form as a check for the PM only and has no further function, but needs to be populated from column C.
Upon choosing a project number, i want the 'Current Forecast Spend' textbox to show the current forecast spend (populated from column D). If the PM wants to update this, he is to input his new forecast spend in a second text box, the contents of which will be updated back onto the worksheet (back to column D). Same procedure for "Costs to date" (column E).
My actual real data sheet has about 3000 rows, which varies from month to month as projects are completed or added.
I've made a start, but I'm afraid i need as much help as i can get!! I understand this may be a very big ask for a first post.
I guess the first problem i have is how to display only unique PM Names from Column A in the Project Manager Name dropdown box. I've managed (after searching through many of the other threads on this site) to create some code that does indeed populate the first drop down, but shows all of the values in col A, not just the unique values.
Bookmarks