Copy and format.

[Gazruss]

hey,
Was wondering if one of you guru's can help

I have a workbook, on tab 1 i have 4 column's of info, on tab 2 i have the same 4 columns of info and a bunch of other columns. I need tab 2 to copy the items from tab 1 when they are entered. I have done a link cell copy, but the cells on tab 2 show "o" in them. I was looking for a way to hide the "o" using a conditional format or something so they only appear when info is added in tab 1

Excel 2010

 

[pedro-egoli]

Assuming cells start in Column A insert this formula in cell A1 of Tab 2.
In need rename Sheet 1 to refer to tab name in your workbook.

=IF(Sheet1!A1="","",Sheet1!A1)

Once entered drag it down as far as you need and drop it.

Do this for each column

Pedro