| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linked data
Is there a way to create a macro or formula or a cell format to populate a
cell that is getting info (external data) from a link to a cell in another worksheet so that it just inserts an "X" or something like that IF the source cell is NOT NULL (or not empty)? |
|
#2
|
|||
|
|||
|
One way:
=IF(Sheet1!A1<"","X","") In article , "Task Lead Nicole" <Task Lead wrote: Is there a way to create a macro or formula or a cell format to populate a cell that is getting info (external data) from a link to a cell in another worksheet so that it just inserts an "X" or something like that IF the source cell is NOT NULL (or not empty)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Controlling Linked Data to Workbooks | Excel Worksheet Functions | |||
Linear Mode
