Thanks for reading this :D
ive made, and been using a cricket score sheet for some time now on excel.
for those who dont know all i do is write down names of playes and there
runs they score and so on.
it was all going fine untill i was asked to add up all the totals in games.
basicaly, if there is one i need a general formula or a way of adding up
numbers on different sheets. although here is the twist, when i made a table
for the players names i realised that i need some way of telling it to search
for the name in the seperate sheets. becasue in cricket the batting and
bowling line up can change.
so basicaly i need a way to search for the name and then to add up runs
which is next to it
i hope this is clear
thanks lyndon