Microsoft Excel functional Question
How do I replicate (copy a column contents of Values to another sheet column) of a whole column (with data content) from a primary sheet to an secondary sheet in another column?
When primary sheet is updated (populated with data) the values of replicated column are automatically updated in the column of the other sheet?
I expected a Hyperlink function without specifying single cell replications by reference!
Best Answer
Suppose your data are in (primary) Sheet1!A column and your replica is Sheet2!A column. So you just enter
=IF(NOT(ISBLANK(Sheet1!A1)), Sheet1!A1, "")in cell a1 and then copy it to remaining cells. Hope this helps :-)