| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy data from one spreadsheet to another one using value in cell
Take a look VLOOKUP function or INDEX and MATCH function in Excel Help menu
"gcastle" wrote: I receive a spreadsheet of stores within our company with store number, address, phone, manager, etc info in that spreadsheet. I want to be able to copy address, phone number and other cells from this spreadsheet into cells in a row of a second spreadsheet automatically when the store number is entered into the store number cell of the second spreadsheet. Anyone know how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
Threaded Mode
