E
Elton Law
Dear expert,
I have a file containing 2 sheets
Summary = Names and Marks
Calculation = Contains the breakdown of Marks
Say in Summary sheet.
A1 to B15 are like this.
Names Marks
Chrain 81
Teri 77
Jim 75
Ricky 74
Trudy 74
Pat 68
James 67
Mark 63
Peggy 62
Michael 61
Fred 55
Kim 53
Ray 45
Fiona 42
Say I highlight the cell of Ricky. Then press (use Mouse) a button (will be
done later in cell C1) next to Marks (cell B1).
It can automatically go to search Ricky in sheet calculation.
Say I highlight (cursor) the cell of Peggy, it can automatically go to
search Peggy in sheet calculation. I can see the breakdown then.
The fact is that .... The sequence in Summary can be changed from time to
time.
Secondly, names are more than 232 (I copy/paste few here).
I don't want to set macro for 232 names and search individual names by
clicking individual buttons next to their marks.
Just want to click one button at the cell C1 and if I highlight the cell of
Ray, then search in sheet calculation and go to look for Ray's breakdown of
marks.
That can save space and can time.
Also, this can be customized for next year (different people each year)
Thanks,
I have a file containing 2 sheets
Summary = Names and Marks
Calculation = Contains the breakdown of Marks
Say in Summary sheet.
A1 to B15 are like this.
Names Marks
Chrain 81
Teri 77
Jim 75
Ricky 74
Trudy 74
Pat 68
James 67
Mark 63
Peggy 62
Michael 61
Fred 55
Kim 53
Ray 45
Fiona 42
Say I highlight the cell of Ricky. Then press (use Mouse) a button (will be
done later in cell C1) next to Marks (cell B1).
It can automatically go to search Ricky in sheet calculation.
Say I highlight (cursor) the cell of Peggy, it can automatically go to
search Peggy in sheet calculation. I can see the breakdown then.
The fact is that .... The sequence in Summary can be changed from time to
time.
Secondly, names are more than 232 (I copy/paste few here).
I don't want to set macro for 232 names and search individual names by
clicking individual buttons next to their marks.
Just want to click one button at the cell C1 and if I highlight the cell of
Ray, then search in sheet calculation and go to look for Ray's breakdown of
marks.
That can save space and can time.
Also, this can be customized for next year (different people each year)
Thanks,