Using Excel 2010
I have spreadsheet, each month on own sheet and, currently, have a Macro to sort the date into ascending order, (day only, ie between 1-28/31) and taking the whole row, of course. See VBA below
Due to other entries being added each month, in addition to those carried forward, there is still the need to sort into date order. If the formula is in the cell, ie "{=Sept!B16}", the date sorting doesn't work, presumably because of seeing the formula and not the date/number.
Is there a way around this so the date can be carried forward from the previous month AND ALSO be sorted by date after new entries have been added?
Any help to achieve this would be very much appreciated.
Many Thanks
%
I have spreadsheet, each month on own sheet and, currently, have a Macro to sort the date into ascending order, (day only, ie between 1-28/31) and taking the whole row, of course. See VBA below
Due to other entries being added each month, in addition to those carried forward, there is still the need to sort into date order. If the formula is in the cell, ie "{=Sept!B16}", the date sorting doesn't work, presumably because of seeing the formula and not the date/number.
Is there a way around this so the date can be carried forward from the previous month AND ALSO be sorted by date after new entries have been added?
Any help to achieve this would be very much appreciated.
Many Thanks
%
Code:
Sub Date_Order_1()
'
' Date_Order Macro
' Puts Date (Column B) in ascending order
'
' Keyboard Shortcut:
ActiveSheet.Unprotect Password:=""
With ActiveSheet
.Unprotect
.Range("A16:BZ115").Sort Key1:=Range("B16"), Order1:=xlAscending
.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End With
ActiveSheet.Protect Password:=""
End Sub