Multiple sheets

Hi Shemelle,

Thank you for the forum question.

There is always a way to do everything working with Excel, but it is not always easy. What you want can be done using Excel VBA coding or an SQL query. If you do not have knowledge using SQL or VBA coding you unfortunately have to copy and paste.

If you are have related data in the sheets (not the same headings). It could one table with all the staff members identified by a staff id and another table/sheet where the staff members projects are identified by their staff id.

If you have related tables you can create relationships between the sheets and then do what you want.

But again unfortunately not an easy solution. You will have to understand how to create a data models in Excel, PowerPivot or use MS Query.





Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector