Ago
04-27-2010, 08:13 AM
I thought i was done with the hard part of my summary workbook, but i dont know how to find the values i need the easiest way.
The workbook is linked to other workbooks, hopefully you will just get a errormessage that the cells could not get updated.
Sheet 1 (Summary) contains a list of files i have in the same folder and the best numbers of those files.
The list is updated by a workbook_open() macro (which i disabled so it wont run on your computer) and works.
Now i need to find a way to update the sheet Records, which will sort out the best of the best. So this sheet will give me my personal records (high and low).
But heres the problem, how do i do that?
I know the numbers are in sheet Summary but for example to find the highest horizontal speed i need to compare the numbers in cell E3, E7, E11 and E15, for now but if i add one more set of data it will be E19 too.
I thought of a loop but that would mean i had to loop 14 times to fill the Records sheet.
The plan is to place the values in C column in Records sheet and a hyperlink filename in column D to the file.
Any suggestions?
I dont expect anyone to solve everything, just give me a hint or a start.
The workbook is linked to other workbooks, hopefully you will just get a errormessage that the cells could not get updated.
Sheet 1 (Summary) contains a list of files i have in the same folder and the best numbers of those files.
The list is updated by a workbook_open() macro (which i disabled so it wont run on your computer) and works.
Now i need to find a way to update the sheet Records, which will sort out the best of the best. So this sheet will give me my personal records (high and low).
But heres the problem, how do i do that?
I know the numbers are in sheet Summary but for example to find the highest horizontal speed i need to compare the numbers in cell E3, E7, E11 and E15, for now but if i add one more set of data it will be E19 too.
I thought of a loop but that would mean i had to loop 14 times to fill the Records sheet.
The plan is to place the values in C column in Records sheet and a hyperlink filename in column D to the file.
Any suggestions?
I dont expect anyone to solve everything, just give me a hint or a start.