Making a list from a new list.

[compynei]

Hi all,

I am creating an Excel whereby we log Maintenance work that is to be done; this will be inputted by an admin team in this sheet:

As there are several maintenance departments I want to create 'branches' off hte main sheet. I.e. on the Security sheet this will show any jobs from the main sheet where I3 shows the job as outstanding and where G3 shows it assigned to that departments sheet. Security sheet is here as an example.

If in the main sheet it is outstanding and for that department then the values from hte relevant cells should be displayed. There could be upto 200 jobs at any one time so they must all be copied line by line and not repeated.

Hope this makes sense, I shall appreciate any help.

I realise there are filters etc. that I could use but this sheet will be exported so it must have its own sheet per dept.

Thanks!

 

[gebobs]

IMHO, you should just have one sheet and filter it by department and status as needed. This is readily facilitated by using the Format as Table functionality. Then perhaps just have a Master/****pit sheet that lists each department and the number of outstanding jobs assigned to it.

 

[compynei]

IMHO, you should just have one sheet and filter it by department and status as needed. This is readily facilitated by using the Format as Table functionality. Then perhaps just have a Master/****pit sheet that lists each department and the number of outstanding jobs assigned to it.

I realise this is a possibility however I need extract by department and output as a printable sheet which will be issued as job lists printed in a presentable format with different headers so unfortunately this isn't a possibility; hence looking for some expert help with the formula!