ENTER DATA EXCELL SO RELATED DATA APPEARS

[Guest]

USING EXCELL 2003: I WANT TO BE ABLE TO ENTR DATA IN A CELL AND HAVE RELATED
DATA (STORED IN WORKS DATABASE) AUTOMATICALLY INSERT INTO SPECIFIED CELL IN
WORKSHEET.

 

[TommySzalapski]

You may need a macro.
You could try a bunch of If functions or VLookups with links to the
file you are pulling from, but if you want it to do a lot of checking,
you will probably need a macro of some kind.
Please be more specific as to what you are trying to do.
And turn off Caps Lock.

Szalapski

 

[Guest]

You may need a macro.
You could try a bunch of If functions or VLookups with links to the
file you are pulling from, but if you want it to do a lot of checking,
you will probably need a macro of some kind.
Please be more specific as to what you are trying to do.
And turn off Caps Lock.

Szalapski
Mr. Szalapski:

Thanks for the tip. If functions with vlookups did the trick.thank you so
much!!!
P.S. whats with the no caps lock rule. I must have broken etiquette so
SORRY!!