+ Reply to Thread
Results 1 to 1 of 1

Copying from main sheet to new sheet if cell contains certain text

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Copying from main sheet to new sheet if cell contains certain text

    Hi - really grateful if someone can help me as this is all a bit beyond me...

    I have created a sheet which contains events which are happening during various months next year.

    What I would like to do is use a formula/code that means that if the 'MONTH' column contains the word January then the row will copy across to the sheet which contains just the events for January.

    I would then want to repeat this for each month so I can have 12 individual sheet in addition to the main one with listings broken down by month.

    The way I have done it on the attached sheet is by filtering the main sheet and then pasting onto a new sheet but the sheet is worked on by many people, some of whom forget to do this so it would be much easier if it could be done automatically.

    Can anyone help??

    Thanks
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1