mattmontalto
IS-IT--Management
Hello All,
I am not the most fluent in excel, and I have a task that I am trying to accomplish that I need some assistance with. Let me explain the situation:
I have an application that is able to total the number of times a characteristic is chosen in a given month for a number of different characteristics. This application allows me to export the data set to excel. However, it comes out as a bunch of columns the represent the characteristics and a variable number of rows indicating all the records retrieved for a given month.
The only row of concern to me is the last one which has all the totals of the characteristics. This row number changes with every export, but the columns are always the same.
What I need to do is be able to take the data that is in each columns last row and put it into another excel sheet... preferable one that I can setup as a template. The reason for this is that the data when first exported is not easy to look at and decipher, but if I can just take the totals and put them into a template, my end users would be able to use it productively.
Any ideas how I can accomplish this anyone? Thank you
Matt M
I am not the most fluent in excel, and I have a task that I am trying to accomplish that I need some assistance with. Let me explain the situation:
I have an application that is able to total the number of times a characteristic is chosen in a given month for a number of different characteristics. This application allows me to export the data set to excel. However, it comes out as a bunch of columns the represent the characteristics and a variable number of rows indicating all the records retrieved for a given month.
The only row of concern to me is the last one which has all the totals of the characteristics. This row number changes with every export, but the columns are always the same.
What I need to do is be able to take the data that is in each columns last row and put it into another excel sheet... preferable one that I can setup as a template. The reason for this is that the data when first exported is not easy to look at and decipher, but if I can just take the totals and put them into a template, my end users would be able to use it productively.
Any ideas how I can accomplish this anyone? Thank you
Matt M