How can I?

[shakaka]

I have an excel spreadsheet, currently there is one tab.
The tab's rows are constantly being updated. Each row has about 30 columns.
I have a column which is called Hardware/Software, when someone enters data into the spreadsheet they will fill in whether its a hardware or software issue, what I am looking to do is to keep this main tab as it is, however I would like to have 2 seperate tabs called hardware and software. I would like these tabs rows to auto populate. So all Hardware is then linked in the hardware tab and all software in linked in the software tab. Also if any changes are main on the main tab it will be automatically updated in the Hardware/Software tab.

Is this possible in excel or is this more of an MS Access feature?

Thanks in advance.

[NBVC]

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST