asked on

Adding Data to Multiple Tabs

Hi, I'm using MS Excel 2010. I would like to have a workbook with 2 Tabs (Tab1 and Tab2). Tab1 contains 10 columns. Tab2 only has column 1, 3 and 5 (the exact same data as in Tab1). I would also like to be able to add data to a cell of column1, 3 or 5 in Tab1 and have it update in Tab2.

Thus, if I added data to a new cell in (Tab1, Column3), I would like to see it available when I switch to Tab2.

How would I link my columns (i.e. column 1, 3 and 5) from Tab1 to Tab2?

Thank you,
Fulano

ASKER CERTIFIED SOLUTION

Arno Koster

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Arno Koster

When you are happy with the way it works, you can apply this formula to the rest of the column by selecting the A1 cell in tab2 and dragging the black dot at the bottom-right side of the cell all the way down.

ukerandi

check this file
Example1.xls

Mr_Fulano

ASKER

Got it...is there anyway to avoid the Zeros on Tab2, where the cells in Tab1 are empty?

Right now I have something like this"

Tab1 Tab2
12 12
0 <------------
133 133
25 25
0 <------------
11 11

I'd like to avoid the zeros if possible.

Thanks,
Fulano

Arno Koster

You can change the formula

"=Tab1!A1"

to :

"=IF(Tab1!A1="";"";Tab1!A1)"

Mr_Fulano

ASKER

Hi Akoster, thanks...I also concluded that an IF statement would be the way to go with this.

=IF('Tab1'!A1="","", 'Tab1'!A1)

Thanks for your suggestion!!!
Fulano

Mr_Fulano

ASKER

Excellent!!!