Results 1 to 4 of 4

Modify Macro to search columns before rows

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2013
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    5

    Modify Macro to search columns before rows

    Good Afternoon

    I have a macro in the attached spread sheet which is fab and works like a dream, I just need it to search columns before rows (default I guess). It may be that somebody has booked an appointment at 11am on Tuesday and also at 4pm on Monday (see Client X in the sheet. At the moment the returning list would put Tuesday before Friday but I'd like it the other way around.

    Sadly I can't just sort the list by date as often the returned text is not formatted as a date.

    Many thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Complecate Macro to search value of intersect Rows and Columns with conditions
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-26-2013, 11:00 AM
  2. Macro help to search in all columns and delete rows accordingly
    By JonnyNYC90 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-20-2012, 03:44 PM
  3. Modify Macro Search & Replace Formatting for part of cell
    By tkeiffer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2011, 05:48 PM
  4. Search by more than 2 criteria (help in macro modify)
    By Wiecman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2010, 05:44 AM
  5. [SOLVED] Macro to search across multiple columns and delete rows not containing specific value
    By JenIT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2006, 02:05 PM

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