New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Sorting And Copying Data to another Sheet Based on Date

Macros, VBA, Excel Automation, etc.

Sorting And Copying Data to another Sheet Based on Date

Postby Sudheer » Mon Oct 12, 2015 12:38 am

I Have a Master Data Sheet. In That Sheet I will input The Data of Total Month. Here in this case, The Data from Date 1st to 10th of that Month Should be Copied to another Sheet Named "A" in That WorkBook.
The Data From Date 11th to 20th of That Month Should be Copied to Another Sheet Named "B" in That Workbook.
The Data from Date 21st to 30th of that Month Should be copied to Another Sheet Named "C" in That Work Book Automatically.

Plz Tell How To Automate This using excel and Vba.

Thanks In Advance.
  • 0

Sudheer
Rookie
 
Posts: 2
Joined: Oct 12, 2015
Reputation: 0
Excel Version: 2007

Re: Sorting And Copying Data to another Sheet Based on Date

Postby pecoflyer » Mon Oct 12, 2015 2:12 am

Hi and welcome
please post a sample sheet showing what you have already achieved and where it went wrong. Thx
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 231 guests