Thread: Budget Set Up
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zoomzoom632 zoomzoom632 is offline
external usenet poster
 
Posts: 19
Default Budget Set Up

This works, but I'm looking for the items to be imediatly in a row.

"Bob Bridges" wrote:

Yes, I got the part about wanting the line items in Running --

Oh, RUNNING Budget! I misread; I thought we were getting columns from
Budget Breakdown. Ok, let me look again.... Well, it seems to me you just
want an IF in each cell that you want copied from Running Budget. Something
like this in 'Line Item C'!A3, for example::

=IF('Running Budget'!$B3="C",'Running Budget'!A3,"")

See whether you can figure out what that does, and ask questions if you have
problems with it.

--- "zoomzoom632" wrote:
I want the Running Budget with the columns to match with the specified tab.
The "Budget Breakdown" will just keep a calculation that I will enter, that
tab just lists the "Line Items" and starting amount.

--- "Bob Bridges" wrote:
Ok, I'm looking at your spreadsheet, and your description seems pretty good,
but I'm puzzled about one thing: You say you want (for example) any row in
the Budget Breakdown tab that is marked line item C to appear also in the tab
named Line Item C. But what column(s) are to appear on that tab? I don't
see that the two tabs have any columns in common.

--- "zoomzoom632" wrote:
On the "Budget Breakdown" have a variety of listed items (Line Items). I
want any data on the "Running Budget" that lists C, F, G, H, or I under the
"Line Item" column to appear on it's own tab.

I have already created the tabs, thus everything listed on "Running Budget"
tab with "F" in the line item column would also be list on the tab called
"Line Item F". Only items with "F" in the line item column would be listed
on the tab "Line Item F".