B
bwall
I have question about autocompleting cells with information. i wante
to initially use access for this, but ther person that needs thi
insists that he wants to use excel.
When he fills out his sheets he wants to have the cell autocomplete th
rest of the ID # and the name when he starts to type in a cell.
I was wondering if this could be done by loading a sort of clien
information sheet, worksheet, whatever with the client id # and name.
Then have a dropdown box or combo box to pull the client id informatio
from the sheet were it is kept. The same being done with the nam
(possibly just auto completing name with the correct id number i
entered or vice versa).
I have imported the table from access into an excel file. I starte
all these tasks in access before I heard that excel was preferred.
I have some other cells were I used the data validation in excel t
load a dropdown list of options to fill the cell. This is ok for thes
few cells, but more clients may be added to the client sheet and I woul
like to be able to add them to the client sheet and have them fill int
the dropdown for the client ID and client name on the report sheet
that I have laid out that are spoken of above.
Is there a simple way or a way to perform these actions of loading an
pulling info from another sheet that has the client id and number s
that it doesn't have to be typed in everytime on the sheet that th
paper reports are put into.
I don't want to get into any crazy coding, because I think that thi
could be done without all this in access
to initially use access for this, but ther person that needs thi
insists that he wants to use excel.
When he fills out his sheets he wants to have the cell autocomplete th
rest of the ID # and the name when he starts to type in a cell.
I was wondering if this could be done by loading a sort of clien
information sheet, worksheet, whatever with the client id # and name.
Then have a dropdown box or combo box to pull the client id informatio
from the sheet were it is kept. The same being done with the nam
(possibly just auto completing name with the correct id number i
entered or vice versa).
I have imported the table from access into an excel file. I starte
all these tasks in access before I heard that excel was preferred.
I have some other cells were I used the data validation in excel t
load a dropdown list of options to fill the cell. This is ok for thes
few cells, but more clients may be added to the client sheet and I woul
like to be able to add them to the client sheet and have them fill int
the dropdown for the client ID and client name on the report sheet
that I have laid out that are spoken of above.
Is there a simple way or a way to perform these actions of loading an
pulling info from another sheet that has the client id and number s
that it doesn't have to be typed in everytime on the sheet that th
paper reports are put into.
I don't want to get into any crazy coding, because I think that thi
could be done without all this in access