Need help in how to filter data
 

Greetings.
Here is a problem I am trying to solve. I have some test cases that can be
run on different platforms defined in a spreadsheet. I would like to keep
the master that has everything, then create an individual spreadsheet for
each platform. Here is some example data from the master (simplified data)

Test ID Summary WindowsXP Vista Linux Other
Test1 Open File x x
Test2 Close File x x x
Test3 Use ls x x
Test4 Delete File x x x x

I would like to create 4 additional sheets with ONLY the data for the
platform specified. So the WindowsXP would show

Test1 Open File x
Test2 Close File x
Test4 Delete File x

I can get it to 'kinda' work using an advanced filter. However if I make a
change to the master, I need to have the change update all the others if it
applies. The list is dynamic, and changes frequently. I know I could just
rerun the advanced filter, but am hoping for a better solution. I haven't
done much macro code in excel, but am willing to take a shot if needed.
Thanks in advance for all your ideas.

Need help in how to filter data
 

Ken
You say "The list is dynamic, and changes frequently." This "dynamic",
does that entail only adding an "x" or does it include removing an x? If
so, do you want that row in the platform sheet removed when the x in the
corresponding row in the master is removed? Otto
"KenK" wrote in message
...
Greetings.
Here is a problem I am trying to solve. I have some test cases that can be
run on different platforms defined in a spreadsheet. I would like to keep
the master that has everything, then create an individual spreadsheet for
each platform. Here is some example data from the master (simplified
data)

Test ID Summary WindowsXP Vista Linux Other
Test1 Open File x x
Test2 Close File x x x
Test3 Use ls x x
Test4 Delete File x x x x

I would like to create 4 additional sheets with ONLY the data for the
platform specified. So the WindowsXP would show

Test1 Open File x
Test2 Close File x
Test4 Delete File x

I can get it to 'kinda' work using an advanced filter. However if I make
a
change to the master, I need to have the change update all the others if
it
applies. The list is dynamic, and changes frequently. I know I could
just
rerun the advanced filter, but am hoping for a better solution. I haven't
done much macro code in excel, but am willing to take a shot if needed.
Thanks in advance for all your ideas.

Need help in how to filter data
 

Otto,
By dynamic I mean it changes both with adding or deleting an X in the
column, but most it will be inserting new lines in the middle of the sheet.
In the example it may be something like
Test 2A Close file not opened x x
If the x is removed, I would like the entry to not appear in the created
sheet.
Thanks for your response.


"Otto Moehrbach" wrote:

Ken
You say "The list is dynamic, and changes frequently." This "dynamic",
does that entail only adding an "x" or does it include removing an x? If
so, do you want that row in the platform sheet removed when the x in the
corresponding row in the master is removed? Otto
"KenK" wrote in message
...
Greetings.
Here is a problem I am trying to solve. I have some test cases that can be
run on different platforms defined in a spreadsheet. I would like to keep
the master that has everything, then create an individual spreadsheet for
each platform. Here is some example data from the master (simplified
data)

Test ID Summary WindowsXP Vista Linux Other
Test1 Open File x x
Test2 Close File x x x
Test3 Use ls x x
Test4 Delete File x x x x

I would like to create 4 additional sheets with ONLY the data for the
platform specified. So the WindowsXP would show

Test1 Open File x
Test2 Close File x
Test4 Delete File x

I can get it to 'kinda' work using an advanced filter. However if I make
a
change to the master, I need to have the change update all the others if
it
applies. The list is dynamic, and changes frequently. I know I could
just
rerun the advanced filter, but am hoping for a better solution. I haven't
done much macro code in excel, but am willing to take a shot if needed.
Thanks in advance for all your ideas.

Need help in how to filter data
 

Ken
I think I can help you with that. I have a couple more questions. I am
not clear on what you want when an "x" is removed in the Master. The code I
will write (this will require VBA) will copy over to the platform sheet when
an "x" is placed. Now when an "x" is removed, you say "If the x is removed,
I would like the entry to not appear in the created sheet." Do you mean you
want the platform sheet row for that entry to be removed/deleted?
Another question: You use the term "created sheet". Do you want the code
to create a new sheet if a sheet for that platform does not already exist or
are all the platform sheets already in place? If you want the code to
create a new sheet, tell me what you want on that sheet in the way of
layout/headers/title/name. In your original post, you have the Platform
names as the column headers in the Master sheet. Are these headers also the
names of the respective platform sheets? Exactly the same?
The code I plan to write will go something like this: In the Master sheet,
if an "x" is placed/removed in the range such-and-such, do this and that.
Tell me what you can about what this range should be. For instance: The
range is all columns from Column C to the last column that has an entry in
Row 1, and any row after row 1. Or anything else to describe the range
where an "x" might be placed/removed.
A lot of my questions could be answered if I could see your workbook/file.
If you wish, send me your file (or a dummy of it). I need only the layout
of the file. My email is . Remove the "extra"
from this address. Otto
"KenK" wrote in message
...
Otto,
By dynamic I mean it changes both with adding or deleting an X in the
column, but most it will be inserting new lines in the middle of the
sheet.
In the example it may be something like
Test 2A Close file not opened x x
If the x is removed, I would like the entry to not appear in the created
sheet.
Thanks for your response.


"Otto Moehrbach" wrote:

Ken
You say "The list is dynamic, and changes frequently." This
"dynamic",
does that entail only adding an "x" or does it include removing an x? If
so, do you want that row in the platform sheet removed when the x in the
corresponding row in the master is removed? Otto
"KenK" wrote in message
...
Greetings.
Here is a problem I am trying to solve. I have some test cases that can
be
run on different platforms defined in a spreadsheet. I would like to
keep
the master that has everything, then create an individual spreadsheet
for
each platform. Here is some example data from the master (simplified
data)

Test ID Summary WindowsXP Vista Linux Other
Test1 Open File x x
Test2 Close File x x x
Test3 Use ls x x
Test4 Delete File x x x x

I would like to create 4 additional sheets with ONLY the data for the
platform specified. So the WindowsXP would show

Test1 Open File x
Test2 Close File x
Test4 Delete File x

I can get it to 'kinda' work using an advanced filter. However if I
make
a
change to the master, I need to have the change update all the others
if
it
applies. The list is dynamic, and changes frequently. I know I could
just
rerun the advanced filter, but am hoping for a better solution. I
haven't
done much macro code in excel, but am willing to take a shot if needed.
Thanks in advance for all your ideas.