Hi,
I have been able to create a marco to organise large quantities my scienfitc data with the grateful assistance of much more able programmers than I.
I need to make the macro a bit more like a template and also make it more flexible to use. Certain parameters change over time (i.e the no of data points Columns Title A, B,C,D,E etc)
I would like the marco when it rearranges the data to automatically highlight all the rearranged data (Columns E2 to M2) until it reaches a blank cell and stop. I would then like the time column (Column D) to fill down until it reaches the end of data rather than manually filling in the cell range in the macro.
After the data is fully arranged I would to draw the x-y graph. At the moment my macro only highlights my selected cell range and then makes the graph.
I am including a excel file of what I am trying to achieve.
Thanks,
Frank
I have been able to create a marco to organise large quantities my scienfitc data with the grateful assistance of much more able programmers than I.
I need to make the macro a bit more like a template and also make it more flexible to use. Certain parameters change over time (i.e the no of data points Columns Title A, B,C,D,E etc)
I would like the marco when it rearranges the data to automatically highlight all the rearranged data (Columns E2 to M2) until it reaches a blank cell and stop. I would then like the time column (Column D) to fill down until it reaches the end of data rather than manually filling in the cell range in the macro.
After the data is fully arranged I would to draw the x-y graph. At the moment my macro only highlights my selected cell range and then makes the graph.
I am including a excel file of what I am trying to achieve.
Thanks,
Frank
Attachments
-
38 KB Views: 74