How to copy names from one sheet to another with just a click

Jaimie Thomas - Oct 12, 2016 at 01:55 PM
 Blocked Profile - Oct 12, 2016 at 05:41 PM
Hello! I am tasked with creating an employee assignment spreadsheet.

I cant seem to figure out how to easily formulate clicking names (around 10) from my employee database [around 80 (sheet 1)] and have them pull over to my assignment (sheet 2) to be printed.

In a perfect world I would click the names, they would auto insert into the column, and sort alphabetically. I'm just a secretary and am worried my boss has placed too big of a project on my lap!

1 response

Blocked Profile
Oct 12, 2016 at 05:41 PM
Well, unless you are stuck with your own code, we are not going to provide you with a turnkey solution. If you post some of of what you have worked on, we would be happy to help.

It seems that if we provide you with a solution, what will happen, is your boss will ask you to modify it (expand on it), and you will come back to the well, as you have not produced the work for yourself. I would encourage you to take your time and do your work. If it takes too long, then let your management know. Unless of course you are a victim of the PETER Principle! Look it up, it is not harassment!