excel information seperation question

[JERD1074]

i have a spreadsheet that has a bunch of information on it. i would like to create several tabs that sort of filter the information by system. there are 10 system, so i created 10 spreadsheet tabs...

i tried the vlookup formula to get specific system data, but it is only getting the first one.

here are my columns:
System Incident Num Date Opened Requestor Description Assigned To

some of my different systems are SAT, PT, SDC. i only want to show the SAT ones in the SDC tab, and only the SDC ones on the SDC spreadsheet etc...

i export the main sheet from an access database every week with new information, so i want the sheets to automatically find anything that should be on that tab and update.

any help would be greatly appreciated.

Thank you.

 

[KenWright]

Why would you not just have it on one sheet and then use any of the filters to home in on particular data. That way you also get to use Pivot Tables on your data, and you will also find you have far more flexibility.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[SkipVought]

Let me ECHO what Ken advised you. If you chop your data up into multiple sheets, you will MULTIPLY YOUR WOES!

It is MUCH EASIER to report from a single source. You have at your disposal, PivotTable, AutoFilter, Advanced Filter, Subtotal, Chart, MS Query, just to name a few.

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[KenWright]

And in actual fact, if you use a Pivot table, get the report you would like, throw your System into the Page fields, you can actually create output sheets for each system in a fraction of a second using the 'Show pages' option.

Nice tutorial to be found here:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------