pominoz
05-30-2012, 04:32 PM
Hi All,
I am completely new to this site and very new to the idea of VBA.
I am hoping that some of the experts here may be able to help me out.
I have a large amount of data, original data worksheet contains around 11000 rows of data (I have attached a spreadsheet containing 100 rows of this data)
Currently I manually analyze this data (using pivot tables) to create a table which I can then calculate lower/upper qaurtile and median salary + percentages of benfits etc (all of this is included as an example in my spreadsheet. From the data table that I create I then create individual worksheets of each role and lay it out ready for export into a pdf file.
Basically I need a sheet for each role that contains the data shown on each role worksheet in my example.
Some of the difficulties are brought about by the fact that the original data often needs to be correctly formatted before it can be analyzed and contains numbers in text format etc.
Please see attachment and let me know if anyone might be able to help.
Thanks a lot
pominoz
I am completely new to this site and very new to the idea of VBA.
I am hoping that some of the experts here may be able to help me out.
I have a large amount of data, original data worksheet contains around 11000 rows of data (I have attached a spreadsheet containing 100 rows of this data)
Currently I manually analyze this data (using pivot tables) to create a table which I can then calculate lower/upper qaurtile and median salary + percentages of benfits etc (all of this is included as an example in my spreadsheet. From the data table that I create I then create individual worksheets of each role and lay it out ready for export into a pdf file.
Basically I need a sheet for each role that contains the data shown on each role worksheet in my example.
Some of the difficulties are brought about by the fact that the original data often needs to be correctly formatted before it can be analyzed and contains numbers in text format etc.
Please see attachment and let me know if anyone might be able to help.
Thanks a lot
pominoz