Create new worksheets using date data

Closed

Erich - Jan 11, 2018 at 09:19 AM
Blocked Profile - 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.

Create new worksheets using date data
Transfer data from one excel worksheet to another automatically - Guide
Tmobile data check - Guide
How to create @ in laptop - Guide
Create new instagram account without phone number - Guide
Create samsung account - Guide

2 responses

Answer 1 / 2

Blocked Profile
Jan 11, 2018 at 04:46 PM

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.

Erich
Jan 11, 2018 at 04:47 PM

We were hoping for something a bit more automated. I'm fully aware of what sorting can yield.

Blocked Profile
Jan 11, 2018 at 04:54 PM

Take a look here, the examples at the bottom will help out!

https://ccm.net/faq/53497-how-to-manipulate-data-in-excel-using-vba

Answer 2 / 2

Blocked Profile
Jan 11, 2018 at 04:58 PM

Here is a quick bone:


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

Similar discussions

How To Fix Mint Mobile Data Not Working?

Why can't I bridge connect?

Hosted app data will not clear

Unlock safe folder without losing any data

Hi Guys how to create an account for facebook with my company em

Similar discussions

Subscribe To Our Newsletter!