Consolidating multiple worksheets

[davidfilce]

Hi, I have several worksheets set up for different work processes such as Training Needs, Occupational Health data, Tool Box Talks received and attendance records.

Each worksheet has the same base data in the first few columns of each worksheet: Employee Number, Surname, Fore name, start date, Department for example

Every time a new person starts employment with us I have to insert a row on each of the sheets and set up the spreeadsheet to do what I need each one to do such as conditional formatting etc

Is there any way I can hold the raw data (names ect) on the left side of the worksheet and view the database on the right depending what worksheet I am analysing at the time?

I hope I am explaining myself properly as I dont know how to upload

 

[James006]

Hi,

Most probably, your easiest path to get a solution is with Power Query

Combine Excel Sheets with Power Query - Xelplus - Leila Gharani

Can you easily combine & clean data from multiple Excel sheets into a single table or Pivot Table? You can easily get this done in Excel with Get & Transform (aka Power Query). Check out the full post.

www.xelplus.com