ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Moving Calculations to a master sheet (https://www.excelbanter.com/excel-worksheet-functions/226906-moving-calculations-master-sheet.html)

cdman82768

Moving Calculations to a master sheet
 
I have a workbook where I calculate pool game match scores and player
handicaps. I have a system page with system named range. Handicaps sheet with
Handicaps named range. Schedule sheet with Players named range. I calculate
the handicaps based on win/loss and then I need to have the final value
returned to the handicaps sheet for the proper player. I use a VLOOKUP to get
the player information including handicap. I just can't figure out how to go
about getting the values returned. I have 6 match sheets named Match 1
through Match 6. I have everything working perfectly except this last step.
Any ideas or help you could give me would be greatly appreciated. I have
almost resigned myself to needing VBA but I have never used it and don't know
where to start. If you need more information I will be glad to give it to you.




All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com