ENTER DATA EXCELL SO RELATED DATA APPEARS
 

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.

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


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=395489

"TommySzalapski" wrote:


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!!


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=395489