Forum Discussion
PLEASE HELP! Auto insert rows to different worksheets in a workbook.
Hi,
i really hope someone can help me!
I have a workbook, which contains many sheets..
I have a list of Names, Departments and start dates of which the employees started…
I need these 3 columns on each sheet, previously i have copied and pasted and any new employees that start or leave i manually have to edit each sheet…
I would like to know… If/When i edit the first sheets first 3 columns, by adding or removing and employee, it will auto update by adding or removing rows in the other sheets on the same workbook?
Please Help!!
A bit of background before I respond to your question: I served for a number of years as the director of the HR/Payroll database system for a major US corporation. So, although I've been retired for two decades now, I have quite a bit of experience with databases such as you're describing here.
And when I read your description of what you have, my first reaction is to wonder WHY you have so many individual sheets in that Workbook you refer to. Your further description does not address what purpose is served by multiple individual sheets. Are they separate sheets:
- for each employee and that employee's history
- for each department and the history of employees assigned to it
- something else
So may I ask you to back up and describe in more detail the structure of your workbook, what kind of data is in each sheet, etc.
Ideally--though you'd have to change names of real people (you could substitute Star Wars characters or some such) and maybe department names as well, so as to preserve confidentiality of the organization--ideally, if you could post a copy or a mockup of your actual workbook on OneDrive or GoogleDrive, that would help a LOT in understanding the situation. Paste a link here that grants access.
As a generalization, I find that a single database for the history of employee assignments--containing dates of transactions (hire, promotion, transfer, ..... all the way through to termination or retirement, and the appropriate details connected with those transactions)--works better as the storehouse of data. From such a single database/storehouse, it's fairly easy, given Excel's many data-manipulation functions, to produce reports on current assignments, histories, etc. So it may be that you'd be better served by considering different ways to organize your data; let's not prejudge the situation, but I hope you're at least open to that if it would be an improvement.
