Hi,
I have been able to create a marco to organise large quantities my scientific 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)
The time column is a variable and requires the use of the formula (e.g. =D2+D$2). But I want the forumla to automatically fill down till the end of the data.
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 automatically highlight the entire data set and draw a x-y graph. At the moment my macro only highlights my selected cell range and then makes the graph. y dataset ranges will change alot
I am including a excel file of what I am trying to achieve.
Thanks,
Frank
Bookmarks