So say i have a spreadsheet. And in this spread sheet i have columns as such
Dept Salary Jan Feb Mar
200 ### Formula's
300 ### Formula's
400 ### Formula's
What i want to do,is add a macro button at the top for each department, that says, add new person to dept, you type in teh persons name, and it then adds a line in that department by alphabelt. So if i had 5 people in dept 400, it would automatically add a line wherever that person would fit in alphabetically. At the same time making it pull down teh forumal's in only the prechoosen choosen columns. Or better yet, you could type in the name, the salary, and then it would enter it where you told it to, and pull down the formula's.
is that possible? I'm familar with how to do macro's and add button's....but nothing this complicated.
If there's any experts out there i'd appreciate advice! Thanks