+ Reply to Thread
Results 1 to 2 of 2

Sort Data on Multiple sheets by single cell Entry

  1. #1
    Forum Contributor
    Join Date
    02-01-2008
    Location
    Perth, Australia
    MS-Off Ver
    Excel 365
    Posts
    135

    Sort Data on Multiple sheets by single cell Entry

    Hi All,

    If possible does anyone have code to do the following.

    On selecting a month using an in cell drop down list on Sheet1, the code will sort the data in all sheets in the workbook to show this selection.
    Only Sheet1 and Sheet2 "hidden template" should not be sorted.

    The selection would be January to december and allow for an all dates selection.
    The dates are listed from sheets3 onwards in Column A, Row 2 and are shown as i.e. 12/06/08.

    Any help will be fantastic.

    Thanks
    Last edited by Zimbo; 09-18-2008 at 02:25 AM. Reason: Poor title and description

  2. #2
    Forum Contributor
    Join Date
    02-01-2008
    Location
    Perth, Australia
    MS-Off Ver
    Excel 365
    Posts
    135

    Some Code

    I have found this code which sort of works,

    It recognises the entry on my fist sheet but does not activate unless I click on sheet 2. It is also only working on sheet 2 and not on 3 or 4 etc.

    Any ideas on what i'm doing wrong?

    Cheers

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I speed up this slow macro?
    By rs2k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2008, 08:34 PM
  2. Date capture in Entry Form to Data Table
    By JIBG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2007, 09:14 PM
  3. locking a data validation list based upon cell value
    By abrazee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2006, 04:46 PM
  4. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 AM
  5. Combine a Matching Column Headings' data in 2 Worksheets to 1
    By ravdog44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2006, 03:42 AM

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