Alright, so yesterday I started messing around with this “colleagues” thing, and I hit a bit of a snag. I wanted to pull in more details about each person, like their department and maybe their start date. That’s where “part 2” comes in.
First, I opened up that same file I was working with before. You know, the one with all the names and basic info. I figured I’d just build on that, rather than starting from scratch. Smart, right?
Getting More Data
- I went back to the original source, like a Company data export.
- I copied and pasted the new data into the file I made yesterday.
- I looked for the columns I needed – “Department” and “Start Date”. Found ’em!
Now, my file has the name, ID, department, and start date for everyone. I made sure to double-check everything because, you know, typos happen.
Making it work part 2
The goal here was to take all of that data together. So I did just that, and tested some stuff to see if it works.
Then I tested it out. Boom! Now, I printed the details for my selected person, and there’s all the extra info, all neatly lined up. Much better than before!
So, that’s pretty much it for “colleagues part 2”. It wasn’t rocket science, but it was a good little exercise in grabbing extra data and making it work. I’m thinking tomorrow I might try to sort them by department or something. We’ll see!
