jbri
12-10-2009, 07:31 AM
The attached Excel file has a formula in columns E & F of the Analysis worksheet that gets information from various rows of the Rated8 worksheet. That is, every time a player finishes a gambling session detail of that session is added into the rated8 worksheet... the analysis worksheet searches for each entry of individual players and sums the collective result [I know the 'expert that will hopefully help with this thread can instantly tell this, but I am giving this explanation for those looking for a similar solution].
The attached file only has a few players (called A,B, C... to H), but the actual analysis workbook has a few thousand players.
The question is when you drag the formula down in columns E&F to the next row each reference name has to be manually changed to the corresponding name in column C. Most names in the real workbook are long and therefore it is not only time consuming (because there are a few thousand to change), but fraught with the potential to make typos that will stop the formula working.
Please, is there a way of incorporating such a change in the formula to do this or a VBA that will.
In anticipation of a solution, I thank you very much in advance.:bow:
The attached file only has a few players (called A,B, C... to H), but the actual analysis workbook has a few thousand players.
The question is when you drag the formula down in columns E&F to the next row each reference name has to be manually changed to the corresponding name in column C. Most names in the real workbook are long and therefore it is not only time consuming (because there are a few thousand to change), but fraught with the potential to make typos that will stop the formula working.
Please, is there a way of incorporating such a change in the formula to do this or a VBA that will.
In anticipation of a solution, I thank you very much in advance.:bow: