Sort descending date VBA

papare

New Member
Joined
Nov 24, 2013
Messages
26
Hello,

Could you kindly assist with the below code, at the moment I use the code to collect data and store it in Sheet Data. The code is linked to a button, i would like to include a sort date which is column C in the Sheet Data. as date can be entered up-hazard.. Many thanks in advance...

Sub upload()


Sheets("Input").Range("C2,C3,C4,C5,C6,C7,C9").Copy
Sheets("Data").Range("C" & Rows.Count).End(xlUp).Offset(1).PasteSpecial _
Paste:=xlPasteValues, Transpose:=True
Sheets("Input").Range("C2:C9").ClearContents

End Sub
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,100,191
Messages
5,473,041
Members
406,843
Latest member
David_Welland

This Week's Hot Topics

Top