Excel Tables Feeding Information

Question

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 input an employee in the master page, and have that information sorted out to the tracker sheets automatically. I tried using SORT(FILTER()) but that only carries the basic information, and leaves the rest of the tracker floating so if the order changes a lot of information is left hanging. I attached some screen shots for reference. My thought is if I could insert this function into a table, it would all stay attached, however I get a SPILL error if I do that.

mathetes · Answer

ECregg&nbsp;&nbsp;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?

ecregg · Answer

mathetes&nbsp;yes, here is a copy of the file template I created.&nbsp;https://1drv.ms/x/s!AkCntsvsFA-cbNsE1QF1aDQPen8?e=iWkah0

mathetes · Answer

ECregg&nbsp;&nbsp;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?&nbsp;Where is it that you're experiencing the SPILL error. Is that on the file you posted? I don't see it.

ecregg · Answer

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.

ecregg · Answer

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.

Forum Discussion

Excel Tables Feeding Information

8 Replies

Resources