davidfilce
New Member
- Joined
- Feb 10, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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
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