Create new worksheets using date data

Erich - Jan 11, 2018 at 09:19 AM - Latest reply: ac3mark 8634 Posts Monday June 3, 2013Registration dateModeratorStatus January 19, 2018 Last seen
- Jan 11, 2018 at 04:58 PM
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.

See more 

4 replies

Reply to this topic
ac3mark 8634 Posts Monday June 3, 2013Registration dateModeratorStatus January 19, 2018 Last seen - Jan 11, 2018 at 04:46 PM
0
Helpful
2
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.
We were hoping for something a bit more automated. I'm fully aware of what sorting can yield.
ac3mark 8634 Posts Monday June 3, 2013Registration dateModeratorStatus January 19, 2018 Last seen - Jan 11, 2018 at 04:54 PM
Take a look here, the examples at the bottom will help out!

http://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba
Respond to ac3mark
ac3mark 8634 Posts Monday June 3, 2013Registration dateModeratorStatus January 19, 2018 Last seen - Jan 11, 2018 at 04:58 PM
0
Helpful
Here is a quick bone:

Private Function copyRow(whatrow, whatsheet)
ActiveSheet.Paste Destination:=Worksheets(whatsheet).Range("A" & whatrow)
Application.CutCopyMode = False
End Function


Respond to ac3mark