ExcelBanter - Linked data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Linked data (https://www.excelbanter.com/excel-worksheet-functions/8859-linked-data.html)

Task Lead Nicole

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)?

JE McGimpsey

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)?

All times are GMT +1. The time now is 10:00 AM.