W
werdna
Right, I have a list of individuals like this...
[SURNAME] [FORENAME] [SEX] [GROUP]
[] denotes a cell.
This is all on one sheet.
On another sheet I have further details of the clients and thi
information (on the first sheet called 'list') is repeated usin
this....
='List'!A2 etc...
In the cells.
This is frozen (freeze panes fuction) to the left with the furthe
details you are able to scoll without loosing their name - on th
right.
Now, I have a sheet which is hopefully going to allow me to vie
details in a different way. I've coloured it blue and designed
temporary layout.
It has these bits....
Forname: [EMPTY CELL] Sex: [DROPDOWN]
Surname: [EMPTY CELL] Group: [DROP DOWN]
When you select the persons name and everything I want it to find th
person and display their details. I thought one way of doing this wa
for the user to type in the above, then click a button. This would the
do the search and the persons details (the ones from the second sheet
to the right of the frozen pane) could be shown below, sort of embedde
so you can still scroll along the bottom.
I'd like to protect the data that showed here so it couldnt be edite
from this viewing sheet. To they would go elsewhere for that!
Does this make sense? If so can anyone offer a solution.
I do have the autofilter option at the moment, but thought it would b
good it they could search this way
[SURNAME] [FORENAME] [SEX] [GROUP]
[] denotes a cell.
This is all on one sheet.
On another sheet I have further details of the clients and thi
information (on the first sheet called 'list') is repeated usin
this....
='List'!A2 etc...
In the cells.
This is frozen (freeze panes fuction) to the left with the furthe
details you are able to scoll without loosing their name - on th
right.
Now, I have a sheet which is hopefully going to allow me to vie
details in a different way. I've coloured it blue and designed
temporary layout.
It has these bits....
Forname: [EMPTY CELL] Sex: [DROPDOWN]
Surname: [EMPTY CELL] Group: [DROP DOWN]
When you select the persons name and everything I want it to find th
person and display their details. I thought one way of doing this wa
for the user to type in the above, then click a button. This would the
do the search and the persons details (the ones from the second sheet
to the right of the frozen pane) could be shown below, sort of embedde
so you can still scroll along the bottom.
I'd like to protect the data that showed here so it couldnt be edite
from this viewing sheet. To they would go elsewhere for that!
Does this make sense? If so can anyone offer a solution.
I do have the autofilter option at the moment, but thought it would b
good it they could search this way