how to update a worksheet and have data copied to another sheet?
 

I am trying to figure out how to input data into a master worksheet (sheet 1)
and have that data filtered into separate worksheets and keep newest data at
the top of other worksheets (sheets 2 and higher).

For example if I have 5 categories of information A,B,C,D,E and on worksheet
1 i input a new data for category A, I want that data to show up on worksheet
2 which is a compilation of all category A data inputs.

Is this possible with a formula?

how to update a worksheet and have data copied to another sheet?
 

Here's one ticket to achieve it here ..

Take away this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top,
w/o any intervening blank lines. Ditto for lines with "CA", "NV", etc which
will be copied into their respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg we
first formulate one child sheet for "NY", dress it up nicely, then just make
copies of the "NY" sheet, and rename these as: CA, NV, SD, etc.

In your case, the key col would be where
you have the categories of information: A,B,C,D,E
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"tsuriman3" wrote:
I am trying to figure out how to input data into a master worksheet (sheet 1)
and have that data filtered into separate worksheets and keep newest data at
the top of other worksheets (sheets 2 and higher).

For example if I have 5 categories of information A,B,C,D,E and on worksheet
1 i input a new data for category A, I want that data to show up on worksheet
2 which is a compilation of all category A data inputs.

Is this possible with a formula?

how to update a worksheet and have data copied to another sheet?
 

Well, you could do it with a couple of formulae. First of all, put a
formula like this in row 2 of a helper column in the main sheet:

=IF(B2="","-",B2&"_"&COUNTIF(B$2:B2,B2))

For example, the formula might go into F2, and it assumes your
categories are in column B, so change this if necessary. This will
give you a unique sequential number for each of the categories, so if
you have A, A, B, A, C, B, A, B etc entered down column B, then you
will have A_1, A_2, B_1, A_3, C_1, B_2, A_4, B_3 etc in the
corresponding cell in column F.

Then in each of the sheets where you want the category information to
be summarised, you can have a formula like this:

=IF(ISNA(MATCH("A_"&ROW(A1),Main!$F$2:$F$1000,0)), "",INDEX(Main!$A$2:$A
$1000,MATCH("A_"&ROW(A1),Main!$F$2:$F$1000,0)))

which will return the data from column A of the Main sheet where the
category is A (change "A_" to other categories in the other sheets).
Copy the formula down as required in each sheet.

Hope this helps.

Pete

On Jan 4, 12:34*am, tsuriman3
wrote:
I am trying to figure out how to input data into a master worksheet (sheet 1)
and have that data filtered into separate worksheets and keep newest data at
the top of other worksheets (sheets 2 and higher).

For example if I have 5 categories of information A,B,C,D,E and on worksheet
1 i input a new data for category A, I want that data to show up on worksheet
2 which is a compilation of all category A data inputs.

Is this possible with a formula?