Forum Discussion
Help with formula pulling names from one tab to another
EDIT: Added example book. Hi All, I'm trying to pull a list of employees from one tab to another based on their job function's unique code. There are three jobcodes in this department tha...
Hi
It would be much easier if you attach some sample data so we can understand what you exactly require. I appreciate that this may be sensitive data but if you create a few lines with false names and removed the data from the other columns (apart from the headings) that this would help greatly.
BTW - what do you mean by your comment "(hardcoded in so I would separate the jobcodes)"
many thanks
Peter
peteryac60 So sorry about that, I have added an example file to my post.
What I meant by "hardcoded" is that I would type the desired jobcode in and it was not being pulled from another area in the workbook.
Please let me know if any more clarification would be helpful.
Thank you!!
