Prev: Recognizing an Unstable Result
Next: sort 2 columns alphbetic and make dictionary
From: JD on 4 May 2010 22:49
I have a spreadsheet with two tabs. The first tab(A) is manually linked to
the information on tab (B). Tab (B) is subtotaled and whenever I change the
subtotal it causes an error message on Tab A. I want to create a formula that
whenever I make a change to tab (B) tab (A) automatically updates without me
having to link it manually.

Tab A Tab B (Subtotal)
Type Amount
Building Repairs 5000 Building Repairs - Total 5000
Building Maintence 1000 Building Maintenace - Total 1000


From: ozgrid.com on 4 May 2010 22:57
=SUMIF(Sheet1!$A:$A,A1,Sheet1!$B:$B)

Where A1 on Sheet has "Building Repairs"

Or a PivotTable http://www.ozgrid.com/Excel/excel-pivot-tables.htm



--
Regards
Dave Hawley
www.ozgrid.com
"JD" <JD(a)discussions.microsoft.com> wrote in message
news:A7FF477D-FA79-411A-A302-6E9A330D7787(a)microsoft.com...
>I have a spreadsheet with two tabs. The first tab(A) is manually linked to
> the information on tab (B). Tab (B) is subtotaled and whenever I change
> the
> subtotal it causes an error message on Tab A. I want to create a formula
> that
> whenever I make a change to tab (B) tab (A) automatically updates without
> me
> having to link it manually.
>
> Tab A Tab B (Subtotal)
> Type Amount
> Building Repairs 5000 Building Repairs - Total 5000
> Building Maintence 1000 Building Maintenace - Total 1000
>
>

From: trip_to_tokyo on 4 May 2010 23:02
EXCEL 2007

This assumes that there is something in tab B cell B 3 that you want to pull
in to tab A cell A 1.

In tab A cell A 1 type:-

=B!B3

Now whatever is in tab B cell B 3 will get pulled in to tab A cell A 1
automatically.

If my comments have helped please hit Yes.

Thanks.





"JD" wrote:

> I have a spreadsheet with two tabs. The first tab(A) is manually linked to
> the information on tab (B). Tab (B) is subtotaled and whenever I change the
> subtotal it causes an error message on Tab A. I want to create a formula that
> whenever I make a change to tab (B) tab (A) automatically updates without me
> having to link it manually.
>
> Tab A Tab B (Subtotal)
> Type Amount
> Building Repairs 5000 Building Repairs - Total 5000
> Building Maintence 1000 Building Maintenace - Total 1000
>
>
 | 
Pages: 1
Prev: Recognizing an Unstable Result
Next: sort 2 columns alphbetic and make dictionary