How to sort multiple columns with pages

NoSparks · #11 08-11-2018, 12:16 PM

Quote:

Say if I made a mistake when adding a new entry whatever it is, mispelled name, wrong ID, or even found out that I had already had it entered and I want to delete it. How would I go about deleting an entry and have everything else move to where it suppose to?

Just delete it or edit it and run the macro. The macro looks after things.
It's like you said originally... no problem when only dealing with 2 columns.
That's the crutch of what the macro does...
Puts things into two columns on the ScratchPad so they can be worked with.
The sorting is automated there.
Everything on the 8 column sheet is deleted then
50 row chunks are written from the ScratchPad back to the 8 column sheet.

Quote:

Second question is are you putting a macro in the files you are giving me? Reason I'm asking is because I know the code I have has different names in them.

Yes, the files you've posted have no macros in them and the sheets have not been named "Utility ID" nor "GAMES"
I've adjusted the names of the sheets and within the macros to suit the most recent issues.
You'll notice the last file I posted checks if the active sheet is named either Utility ID or GAMES and if it is uses Activesheet rather than the specific name, and if it isn't either gives the Goofy sheet message.
Try it, try running the macro with the ScratchPad being the active sheet.

Quote:

Third question is are these codes/macros file oriented? In other words, the code that you gave me in the beginning, will it only work on the Utility ID file and ScratchPad or can I change the names and use the code for other files I have like the GAMES file I am trying to do which when I try gives me an 'Subscript Out Of Range' error?

That first code can be disgarded and replaced with the last (in thumb_v4.xlsm) as long as the sheet has the same layout as Utility ID and it's name gets added to the check of sheets that it's ok to operate on.
For example if you were to add another sheet for this to work on.

Code:

'make sure dealing with an acceptable sheet
If ActiveSheet.Name <> "GAMES" And ActiveSheet.Name <> "Utility ID" And ActiveSheet.Name <> "whatever sheet" Then
    MsgBox "Goofy Sheet" & vbLf & "Will not continue"
    Exit Sub
End If

Quote:

BTW, thank you so much for helping me out, I don't think I would ever have been able to figure this out myself.

No problem, glad I was able to help.
You're a 65 year old beginner. We all had to start somewhere.
I've got a couple of years on you and only started playing with this stuff (for entertainment) when I retired.

Good Luck with your project.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to sort columns	SerenityNetworks	Excel Programming	4	09-02-2016 06:20 AM
.pdf to .xlsx - How to get sort-able columns?	CCinPA	Excel	0	07-05-2016 08:30 AM
Normal sort not bringing along other columns	Dave Fraser	Excel	2	06-06-2014 11:48 AM
quick replace, sort, change columns	userman	Excel	1	05-01-2012 06:24 AM
How to sort table having three columns?	Bahir Barak	Word	2	01-20-2011 01:52 PM