| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
automatic input of cell values
I have a spreadsheet in which the value of Column A has a corresponding value
in Column B for each row. This spreadsheet serves as the relational data for a second spreadsheet of records. This is what I need to happen in the second spreadsheet: If I enter in the Column A value in a particular cell, its corresponding Column B value from the first spreadsheet should automatically populate itself into another cell within the same record. I assume this would require some sort of macro? Thx -- csc |
|
#2
|
|||
|
|||
|
Check the Vlookup function in help.
You may not need a macro. "csc" wrote: I have a spreadsheet in which the value of Column A has a corresponding value in Column B for each row. This spreadsheet serves as the relational data for a second spreadsheet of records. This is what I need to happen in the second spreadsheet: If I enter in the Column A value in a particular cell, its corresponding Column B value from the first spreadsheet should automatically populate itself into another cell within the same record. I assume this would require some sort of macro? Thx -- csc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| set hypothetical values for a cell | Excel Worksheet Functions | |||
| Toggle multiple values in single cell | Excel Worksheet Functions | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Linear Mode
