| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
| Convert a word address and data list to excell | Excel Discussion (Misc queries) | |||
| I want to create a macro to where after we enter data in a spread. | Excel Worksheet Functions | |||
Hybrid Mode
