Hello
I am currently trying to build a phone call quality log for the reservations department at a hotel and am wondering if I'm going to need to use VBA to achieve what I need. The manager of the department will be listening to recordings of each agent's calls and scoring them on various criteria, but the checks will not be happening on a regular basis or preset number of times.
There will be one sheet per reservation agent along with a master statistics sheet that will pull data from each agent's record and compare/summarize. The individual reservation sheets will have an unknown number of cells to pull data from (ie. the call quality checks will be irregular and will just be added on to the bottom of each sheet as they are completed), so I can't use any of the regular formulas I know (COUNTIF, SUMIF, VLOOKUP, HLOOKUP, etc) because I need to define a range of cells.
I have a feeling this will require some sort of coding in VBA, but am not sure where to start (I've used VBA before, but under the guidance of a programmer and haven't actually written any code myself). Any help will be much appreciated!
I am currently trying to build a phone call quality log for the reservations department at a hotel and am wondering if I'm going to need to use VBA to achieve what I need. The manager of the department will be listening to recordings of each agent's calls and scoring them on various criteria, but the checks will not be happening on a regular basis or preset number of times.
There will be one sheet per reservation agent along with a master statistics sheet that will pull data from each agent's record and compare/summarize. The individual reservation sheets will have an unknown number of cells to pull data from (ie. the call quality checks will be irregular and will just be added on to the bottom of each sheet as they are completed), so I can't use any of the regular formulas I know (COUNTIF, SUMIF, VLOOKUP, HLOOKUP, etc) because I need to define a range of cells.
I have a feeling this will require some sort of coding in VBA, but am not sure where to start (I've used VBA before, but under the guidance of a programmer and haven't actually written any code myself). Any help will be much appreciated!