I was told how to get a textbox to lookup a corresponding number and show
details relating to that particular number but how do I get a macro to
transfer information from one spreadsheet to another using the corresponding
number.
For example

I have player reg # 44 who score 2000

this will goto sheet2

I want a macro to look at a the players number in column "a" and then look
on sheet 1 for the same number and add the 2 totals together and update
sheet 1 with the details

Any help would be appreciated

Greg