Please view my Excel files to better understand what I am talking about...
http://www.geocities.com/bushiebrow2...est_Sample.xls

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".

I hope this make sense, please help if you can, thanks.

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:
Please view my Excel files to better understand what I am talking about...
http://www.geocities.com/bushiebrow2...est_Sample.xls

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".

I hope this make sense, please help if you can, thanks.

Sir,

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:
Please view my Excel files to better understand what I am talking about...
http://www.geocities.com/bushiebrow2...est_Sample.xls

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".

I hope this make sense, please help if you can, thanks.

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".

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".

Mm...I hope you mean "column", not "row", because I was prepared to hear you
say the former. The problem with my suggestion, as I see it, is that it
leaves your rows displayed correctly, after a fashion, but with the gaps
between them that in the source sheet are filled with other line items. So
if on the Running-Budget sheet starting on line 3 you have line items C, G,
C, H, H, C and G, then the sheet for item C will have data on lines 3, 5 and
8, whereas you want them on lines 3, 4 and 5. Right?

Well, you CAN do this with formulae, but it's pretty messy. Much better, I
think, to do it in a VBA program. Are you up for that, or do you really,
really prefer to do it with worksheet functions?

--- "zoomzoom632" wrote:
This works, but I'm looking for the items to be imediatly in a row.

Right, here's how you can do it with Excel's built-in functions. You'll need
a few helper cells and columns. You can put them anywhere, but here's how I
did it in your workbook, using Line Item F as the sample sheet:

I1: The literal "F". (This enables you to use the same formulae on each of
the other line-item sheets.)

J1: ="'Running Budget'!"; this way if you rename that sheet some time down
the road you don't have to go through all your sheets, rows and columns and
rework all the formulae.

I2: =ROW('Running Budget'!B2), to start your first search.

J3: =$J$1&"B"&I2+1&":B999" constructs the address of the area you'll search
for the next "F". In J3 the result is " 'Running Budget'!B3:B999".

I3: =MATCH(I$1,INDIRECT(J3),0)+I2 finds the NEXT occurence of "F" in the
Running Budget sheet, starting in the row after the previous "F" (which in
this first case means starting in row 3). I3's result is 5, which you can
confirm by looking in the Running Budget sheet and seeing that line-item F
first appears on row 5.

After that, J4 shows 'Running Budget'!B6:B999 and I4 is 11, and so on.

That gets you, with a lot of hemming and hawing, to the same information
without blank spaces. For columns A through E use something like this:

=IF(ISERROR($I3),"",INDIRECT($J$1&"R"&$I3&"C"&COLU MN(),FALSE))

....(you'll want to look up that R1C1 notation if you don't already know what
it is, but maybe you do). That pulls in the proper data for the next F row
from the Running-Budget sheet.

There are odds and ends to clean up but maybe this gives you the idea.

--- "zoomzoom632" wrote:
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.