Forum Discussion
Excel Tables Feeding Information
I am attempting to create a training tracker with Excel, where one page holds the employee information (name, number, hiring date) and the other pages hold the position's trackers. The intent is to i...
Images are not really all that helpful. Is it possible for you to post a copy of the actual spreadsheet--ideally with a few (false--use Disney or Star Wars characters) names, and dummy data--posting it on OneDrive or GoogleDrive with a link pasted here that grants edit access?
mathetes yes, here is a copy of the file template I created. Training Template.xlsx
OK, I have the file. Now, if you don't mind, a bit of help navigating it. I'm assuming that what you refer to as "the master page" is the sheet named "Employee Split", but what happens next. What gets tracked? Where?
Where is it that you're experiencing the SPILL error. Is that on the file you posted? I don't see it.
- Yes the employee's information would be entered into the Employee Split Page, which would sort them out to the other pages based on position. I removed the formulae I was using since they did not work for what I was trying to do. The =SORT(FILTER()) was pulling information from the employee split page, but when I entered information to the right of that, in the actual training tracker, it was no longer a table and so was not attached to the names I was entering. If I entered a new name, the training information would not adjust for the new rows.
- The formula I was using is =SORT(FILTER(TABLE1[[EMPLOYEE NAME]:[EMPLOYEE ID]], TABLE1[POSITION]="Position 1","")). With this formula, I had to include an extra table that included the position title again.