Create new worksheets using date data Closed

Question

Hello, 

I've been asked to find a way to sort data comprised of visit dates in to worksheets (within the same workbook) by age. The dates range from early 2016 to late 2017 and we want them aged as follows: 0-30 days old, 31-60, 61-90 and 91-120.

System Configuration: Windows / Chrome 63.0.3239.132

ac3mark · Answer

You can sort right?  
Click on the column you wish to sort by, and sort it.

You have to manually cut and paste the data after sorting.

ac3mark · Answer

Here is a quick bone:
Private Function copyRow(whatrow, whatsheet)ActiveSheet.Paste Destination:=Worksheets(whatsheet).Range("A" & whatrow)Application.CutCopyMode = FalseEnd Function

Create new worksheets using date data

2 responses

Similar discussions

Subscribe To Our Newsletter!