Auto transfer across workbook sheets?

[startrekguru]

Hey all,

I want to create a shift log workbook using excel. I want to have a seperate excel sheet, in the same workbook for each shift. I intend to give each log entry a status, eg. complete, ongoing, needs urgent attention and so on.

So what I want to do is that if for example a log entry has a status of needing urgent attention, that it automatically gets entered in the next shift log sheet without having to manually transfer it across.

Is there a way to do this?

Thanks,

Startrekguru.

[Tinbendr]

Welcome to the board!

You can do this pretty quickly by right clicking the current worksheet tab, copy, and select location.

In the new copy, Data -> filter. Left click over the status column, uncheck urgent. What remains on the sheet is everything that isn't Urgent.

Highlight all except header, right click, delete.

Rename the sheet to the current shift.