| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
I want to know how to "program" a cell (for example A1 on a spreadsheet) so
that when you enter certain data into it (for example, the letter "A"), certain data will automatically appear in other cells (for example the number "24" in cell B1 and the number "35" in cell C1. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
You can use a formula. In B1, use
=IF(A1="A",24,"") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Joe the NY Lawyer" <Joe the NY wrote in message ... I want to know how to "program" a cell (for example A1 on a spreadsheet) so that when you enter certain data into it (for example, the letter "A"), certain data will automatically appear in other cells (for example the number "24" in cell B1 and the number "35" in cell C1. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
Are worksheet formulas suitable? For instance, enter '=If(A1=5,35,"")' into
C1. HTH -Mike "Joe the NY Lawyer" <Joe the NY wrote in message ... I want to know how to "program" a cell (for example A1 on a spreadsheet) so that when you enter certain data into it (for example, the letter "A"), certain data will automatically appear in other cells (for example the number "24" in cell B1 and the number "35" in cell C1. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(EXCEL) HOW TO PROGRAM CELL SO DATA WILL POP UP IN OTHER CELLS
You can do this with the change event.
For an intro to events, see Chip Pearson's page http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Joe the NY Lawyer" <Joe the NY wrote in message ... I want to know how to "program" a cell (for example A1 on a spreadsheet) so that when you enter certain data into it (for example, the letter "A"), certain data will automatically appear in other cells (for example the number "24" in cell B1 and the number "35" in cell C1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My computer keeps speaking out cells in excel, no other program | Excel Discussion (Misc queries) | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| How can I program excel to shift data up to fill empty cells? | Excel Discussion (Misc queries) | |||
| How do I program the cells in Excel to add, subtract, etc? | Excel Worksheet Functions | |||
| breaking a cell into two cells via VBA program | Excel Programming | |||
Linear Mode
