View Single Post
 
Old 11-22-2024, 06:43 AM
Dr. Rick Dr. Rick is offline Windows 10 Office 2010
Advanced Beginner
 
Join Date: Apr 2023
Location: Coastal N.C.
Posts: 32
Dr. Rick is on a distinguished road
Thumbs up

Quote:
Originally Posted by gmaxey View Post
You don't need a macro to do this.


1. Add your temporary column
2. Define the order you want the rows indexed
3. Sort the table on the temporary column
4. Remove the temporary table

It's true, Greg, that I might not NEED a macro for this, but isn't the whole purpose of macro to automate tasks? I'm NOT trying to sound whiny or snarky. I tried the above process and no doubt did something wrong and it didn't produce the results I wanted, so I'm taking the lazy way out and wanting someone else to give me a macro that will accomplish it.


Thanks, however, for confirming that I had the right idea.


I'm sure there must be a way I can do those 4 steps from the keyboard--I'm still trying to get over the fact that one can't include mouse clicks in macros. I was sure I had done so in the distant past when recording a macro, but I was told authoritatively that this probably was not so.


Thanks, anyway. I'll try the hammer and tongs method again and see what happens.
Good day.
RJ
Reply With Quote