Hello Excel Gurus:
I need help for the revision of the VBA code below to sort DESCENDING on the “TR DATE “ (starting from cell Y7).
Any help would be appreciated.
Thank you.
Please Login or Register to view this content.
Hello Excel Gurus:
I need help for the revision of the VBA code below to sort DESCENDING on the “TR DATE “ (starting from cell Y7).
Any help would be appreciated.
Thank you.
Please Login or Register to view this content.
Hello GEMINI52,
There is a lot going on here with references. It would be best if you upload a copy of the workbook for review.
If your workbook contains any personal, private, or confidential information then please redact it before you post.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith Ross,
Here is the file that was requested.
The attached file has 2 sheets, dBase and PubQ1 sheet and has a working code. Type the pub number on cell “B3” and it will display KEY DATE, KEYED BY, TR DATE, TR TYPE, TR QTY, UNIFIED LOC and COMMENT coming from dBase sheet.
The revision I want is result to be sorted (descending) on the TR DATE and display only the 6 column (KEY DATE, KEYED BY, TR DATE, TR TYPE, etc.). As of now the column that I don’t want to show is just hidden.
Also, please check the code to set the print area is correct.
If the code has to be changed, it is most welcome. I have 25,000 rows and it runs slow.
Thank you and hope to receive your revision ASAP.
separate threads merged.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Try replace sheet module code with (Deleted Sheet_Activate code)
Please Login or Register to view this content.
Last edited by jindon; 11-21-2015 at 05:49 PM. Reason: File attached
Thank you for your quick response and will let you know once i tested it. Happy thanksgiving.
Tested the code and it works but a little bit slow on 25K rows. I few more twerks i need on sheet "PubQ1" (if i may?)
The revisions i need:
1. When you type on cell "B3", i want it in all CAPS even if you type in small caps.
2. Keep formatting on destination cells (A8:G)
3. Always set filter from cell (A8:G) and
4. The sheet should be protected.
I am a newbie on macro code, so forgive me for my ignorance.
I hope you can help me again. Thank you...
Not sure about 2).
Sheet protected under "password"
Please Login or Register to view this content.
Hello again,
It works perfectly for my needs, two more request.
1. Can you add a second sort? UNIFIED LOC (ascending)
2. Cell B3 is merge with C3 and D4 and it does not clear A8:G when cell B3 is blank.
Just for curiosity:
CurrentRegion has 6 commas between 2 and True, what does it represent.
Likewise, me.Protect... has 14 commas,
Please educate me.
Thank you...
QUOTE=jindon;4247948]Not sure about 2).
Sheet protected under "password"
[/QUOTE]Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks