Here is the setup:
I have two sheets, the first being a form with some combo boxes and some fields that get populated depending on selections the user makes, and the second sheet holds the data.
Now let me set up the data sheet:
Lets say that the columns are username, state, and time on internet.
Now here is the problem:
I need to add up all the time all the users in a certain state were on the internet depending upon which state is selected on the first sheet.
I accomplished doing all the individual username times for another part of the project using Vlookup. I think that to solve this new problem might require some scripting. I am uncertain how to proceed since I am not that familiar with VB scripting. I think I need to use a loop to search through column 2(state) for the specific state name and then add the value of column(3) time to a variable that can be updated every time through the loop. I am uncertain if this is the way to proceed. Can someone please give some guidance to this problem. Sorry to be a Noob, but I don't use excel that often.
Bookmarks