Not sure how to do this

[Alteran]

I am looking for a way to take a sheet which containes data related to different types of expenditures and have them statically updated into expenditure type worksheets (all in the same book)

So I have the main sheet: Data
and I have 5 type sheets: CC, DRF, DRC, CP and TPD

I would like to use a function to just drag the rows down to get the data that I want however the issue I am having is it takes only the first instance of any type because there are multiple it becomes an issue.

Any suggestions?

 

[Smitty]

Take a look at AutoFilter. You can filter on each criteria, then Goto-->Special-->Visible Cells Only, then copy the selected range to its sheet. If it's one-off just repeat until done. If you need to frequently repeat it then you can record a macro doing it for one, then paste the code here for someone to clean up.

HTH,