Search results for query: *

Hi All, I'm slightly lost with this and have had to resort to forums as I just cannot see what is wrong with the code. In short I have three tabs, Tabelle1 List of data, columns A_L. Sheet 1 A data validation set in A1 which refers to a a list of Line Managers, and a button to activate the...

So I have been given a task at work. Seemingly straight forward, I just can't think of the best approach. We have a spreadsheet of users, job titles and roles assigned to them. We are trying to identify people with assigned roles that differ from the norm, but we have nothing set in stone as...

Hi All!! I have the below which does exactly what I need to do with a spreadsheet, however I have one addition to make which I can't quite suss. To start with, the code - Sub FilteringCP() Dim RngOne As Range, cell As Range Dim LastCell As Long Dim arrList() As String, lngCnt As Long With...

I have the below code which works fine (all be it some of you will look at it and shudder). However I have just had it srpung on me that the materials are alpha numeric (innitially we were told numeric). I didn't think this would be an issue, but the paste special option doesn't work now. I...

Hi All, I've scoured everywhere to find what I am looking for but simply can't get to the bottom of it. Scenario. 1. 3 x mail received with attachments. 2. Attachments are pulled and moved to a folder on my desktop. 3. I need to rename these files sequentially so I can then manipulate them...