adam

Hello, I have a table, something like: <tbody> Column 1 Column 2 Adam Orange Ben Blue Charlie Orange David White </tbody> I want to use a list type validation in another range with the list values being where Column 2 = Orange, so the list would be: Adam Charlie I've Created a...

Hello I just like to pick your brain. I have a column which has the firstname and lastname (one space between them). I want a new column which has the "lastname, firstname". One way I am thinking of is to use Text-to-Columns to separate the firstname from the lastname, then I will use...

Hi all, Hoping for some help. How do I count the accumulative number in row B if it matches criteria in row A. For example Adam would = 5. <tbody> Adam 2 John 2 Adam 3 </tbody>

I'm doing this just to see if I can come up with how to do it. So, I've got a Userform with a single TextBox in it. I want it to auto fill and auto update as I type into it. I feel like I'm close, but I'm using the ".Find" function, and it's acting in a way I can't figure out. Here's the code...

Hi Everyone, I don't think this problem is actually very difficult. But I'm stumped. If you can take a look for me I'd really appreciate it. Basically, I need to summarise all the labour hour costing for each month. I have a list of staff who, for their work each day, record the: jobs, codes...

I've got an interesting problem, where 5 systems contain lists of companies with IDs, and the companies are supposed to be consistent across companies, but I believe they're not, i.e: Company ID 123 may be "Tom Ltd" in the first system, "Adam Ltd" in the second system, etc for 5 systems, but the...