management information

Hi, I deal with MI within my department. At the moment I have a master file where I document weekly stats, however I do it manually. Weekly stats I get in excel format. It always looks the same way: column A: process name column B: items column C: time Then I manually take the stats I need...

I have a list sheet with customer data, see below <tbody> Abraham Gluck 718 111 2121 example@example.com Moses Grace 845 343 3434 example@example.com Miriam & Mindy Smith 347 243 2433 fax example@example.com and@Iol.com </tbody> I want to split off the third row into 2 separate rows, I...

I have a work book that shows financial data in columnar format and I'm trying to create a summary sheet that will pull through the sum of the correct amount of months when specified. I have a drop down box with the months in, and these feed a cell that gives the corresponding number (i.e. Jan...

So this is what i need to happen, I have a HR list and another list for an application Suppose i need to find if the account on the application is on the master list i need to copy the data into a new worksheet (Master List) and if there is no other verification of the account, it will go to...

I have been tasked with creating a dashboard for quarterly board meetings which will include a large number of performance measures and possibly some graphs (either standard excel or sparklines). I created a template for the dashboard in publisher to begin with and tried to copy in the...