Linking blank cell

Deepak Adhikary

Hi,

 

I am not being able to link a blank cell to another sheet.

 

My goal is to make data of few columns of other two sheets identical to the data of master sheet, where my team will fill the cell with data later [Currently it is blank]

 

OR is there any way that i can link the column itself to another sheet ?

 

Thanks.

 

Deepak.

Kara Lumley

Deepak,

 

Here is a trick: 

Select the cells that you want to link, that are currently blank.

Change the background color of the cells to white, using the left hand toolbar. 

Save the change.

 

The system will register the cell as not being "blank" and allow you to set up the cell link.

 

Hope this helps,

Kara