We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Excel help please

Cornwall_Girl · 2013-01-30 14:10:50

I currently have a spreadsheet that has a master sheet holding all data, the sheet is where work will be assigned to individuals. I now want to create a tab per worker, which will (if possible) automatically populate the individual's tab with the full row, when their name is selected against a particular job. Is this…

Comments

Tony_H_3 Posts: 2,643 Forumite

2 February 2013 at 11:31PM

As an alternative, on the master sheet if you use the "auto filter" function you will be able to list the jobs assigned to each staff member. You can use this data to either Print or Perhaps copy to a named sheet.

0