+ Reply to Thread
Results 1 to 5 of 5

sort based on column value before auto printing

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Smile sort based on column value before auto printing

    Hi all,
    I have sheet1 where there is a data from column A to M.
    Currently I have code which will select print area and send it for print.

    I want to add one more aspect:
    Sort the rows first based on cell values in column C grouping similar values rows together.

    e.g. If cell values in column C are ... A1, B2, T3, Z4, X5, A1, B2, T3, Z4, X5
    Then it will organise rows ..... A1,A1,B2,B2,T3,T3,Z4,Z4
    Actual data in sample file is .........
    Please Login or Register  to view this content.

    I have attached sample file which has print code as follows:
    Please Login or Register  to view this content.
    Any help please.

    Kind regards
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Smile sort-based-on-column-value-before-auto-printing

    Please refer to the thread submited by me twice....
    http://www.excelforum.com/excel-prog...ml#post3479908

    For some reason This has come up in strange format where no one can reply .
    That is a reason I am submitting third time now>

    I have found a solution and is as follows:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: sort based on column value before auto printing

    I have corrected the format of your thread. It happens when the title ends with "print".

    Thanks for posting the solution. Am marking your thread as solved.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: sort based on column value before auto printing

    Hi arul1201,
    Thanks for your help.
    Another learning curve
    Kind regards

  5. #5
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: sort based on column value before auto printing

    Hi all,
    Its is indeed worth celebrating.
    Ever since I started learning excel, this is the first time probably that I have found solution on my own.
    A small step forward.
    Thanks to everyone who helped me.
    Kind regards

+ 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. [SOLVED] seeking VBA help to auto sort worksheet based on date in column A
    By leopardhawk in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-29-2013, 12:11 PM
  2. how do you auto sort based on certain column
    By juniperjacobs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2010, 03:28 AM
  3. Auto Sort based on one column
    By tomberlins in forum Excel General
    Replies: 1
    Last Post: 08-25-2009, 12:46 PM
  4. [SOLVED] Printing after using column auto fit - not working
    By Caroline Lackey in forum Excel General
    Replies: 2
    Last Post: 06-09-2005, 12: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