Josh Fisher

Hello, Doesn’t matter i found an alternative solution, was on a tight de3adlin and needed it sorting but cheers anyways.

Hello, added the value 00/00/0000 in the empty fields but no joy still that 20/08/2016 that comes inbetween to other dates :/

Using the command stops the sort function on the column :/

https://goo.gl/xFZJRo / NuclearPenguin and its New Opportunities section, deadline date column

all the dates in the column are in the format dd/mm/yyyy and those without dates are just blank, but its still that one row with the date 20/08/2016 that comes in between the two dates, is it because there is a 0 before the month ?

sorry didnt display correctly

Sub links()
LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For I = 2 To LastRow
    Cells(I, 2).Value = "<a href=" & Chr(34) & "" & Cells(I, 1).Value & Chr(34) & ">" & Cells(I, 3).Value & "</a>"
Next I
End Sub

cheers no problem

Cheers was a big help, I altered the macro to take a link from column A, the title from column B, and produce html code in column C

ColumnB

Sub links()
LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For I = 2 To LastRow
Cells(I, 2).Value = “” & Cells(I, 3).Value & ““
Next I
End Sub

Hope this helps anyone else

Cheers dude found this after I put this comment, you should really combine the two plugins into one, dont see why you have 2 separate plugins for this.

nevermind

Because I don’t have the checkbox underneath my job filter to select weather its permanent, temporary or contract.

Nvm