utility

I need to calculate the total # of calls, texts, & emails facilitated on a company's network each month from Jan 16 - Jan 17. The issue: the data set given to me only contains Summary invoices, which show total volumes grouped by the type of usage over each individual invoice term. Since...

Hi All, Have tried to install newest version of asap utilities. Does not display on tool bar. When I go Tools>>Addins>>Browse and select the asap utility it says it is not a true addin?:confused: Any suggestions? Forgot to mention I use Excel 2003 but I have Excel 2013 on computer. The ASAP...

Hi, I had locked excel files using LockXls utility but unfortunately I misplaced my original excel files. Does anyone know how to restore the original files. If I use their utility to decrypt, they want hardware id that I don't have. Thanks

Hi All, I have a budget table which I need a little bit of formula help with. So when I select the option of Paid I would like it to deduct the value from the total providing me with the remaining balance. Please see below example of how I would like it to work; <colgroup><col style="width...

Hi, I've got a sheet with data as follows <tbody> Client Name 1 Name 2 Name 3 1234 Passport DL Utility 456 Passport DL Utility 778 Passport DL Utility </tbody> I wanted to concatenate only if the cells or font is formatted with the colour red and list the items in separate lines...

I have created a 'utility' workbook that contains a number of macros that coworkers & I use for various processes. Since each of the processes to be completed is always done on a workbook that a user opens, I'd like to automate always returning to the previously 'active' workbook. I've been...

Hi smart ppl, I have been pulling my hair out trying to write a set a vba codes that normalize utility bills into actual calendar month. So far I have.. Column A as Reading Dates (In order from Jan-Dec) (eg. January 15, 2015) Column B as Year (In order from smallest to largest) (eg. 2015)...