Forum Discussion
Drop Down Menu For Sections
Hello! I have been lurking this forum for ages, picking up tips and tricks to better my skills. But now I have hit a wall.
I am building an employee hierarchy for my job that is separated by Offices on a single sheet. I want to place a dropdown menu for Location that will automatically move entire rows when assigned to that Office Section on the sheet.
Each office does not have a uniform amount of people - the number changes regularly. I just want to build some ease in moving them between offices with their data. Is this possible?
1 Reply
no but sort of. So cell formulas can NOT move data, they can only show the result of a calculation/formula.
To actually move data you would have to use VBA/macro or use a Script.
That said, I would recommend what you CAN do is have a master table to ENTER data and then multiple OUTPUT tables. Those output tables could use cell formulas or pivot tables or power query. So the INPUT table would contain all the input data. NOTE the "input" table could be multiple tables. So you could have a personnel table that has their ID#, name, address, job, etc... and then another table could be Work Hours and have their ID, Date, and hours worked. The idea is that you set up input tables that contain all the information. So the 'Office' info could be on the personnel table I noted above or could be its own table if you want to track when they move from 1 office to another office.
Then you can create the 'report' format where you query the relevant data accordingly. In the simple case where the 'office' is a column in the personnel table above then when you change that value the output tables for each 'office' would automatically update and "move" that person accordingly.
