Code required to order data in a table when a button is clicked

**CPAC** · 11-21-2018, 08:33 AM

Hi, I need help to arrange the data in the table by increasing thickness ("INPUT" sheet column "F"). I need all the corresponding information from columns B,C,D,E, & H to be moved in order with their original thickness in column F. I hope this makes sense

Any help would be much appreciated.

Thanks,
Jeremy

**Arkadi** · 11-21-2018, 08:54 AM

Hi CPAC (Jeremy),

I noticed you do have a header for column A, so you may need to adjust the code if you want that included, but I went by the specs you provided:

Please Login or Register  to view this content.

**CPAC** · 11-21-2018, 09:16 AM

Perfect

. Any idea how I can stop it jumbling the grey white line colours when it does the order?

**Arkadi** · 11-21-2018, 09:54 AM

I assume you manually coloured the rows?
If you format as table instead, then it will work, except all the blanks end up on top.
Perhaps in this case it would be best to apply conditional formatting to colour the rows in alternating fashion, that way the sort will maintain colouring.
A post detailing that (quite old but applicable) can be found here

**CPAC** · 11-21-2018, 01:56 PM

That's great, thank you for the help.

**Arkadi** · 11-21-2018, 02:04 PM

Glad I could help

Thanks for the rep and the feedback, please remember to mark the thread as solved if you are satisfied? Thanks!

**CPAC** · 11-22-2018, 11:00 AM

Hi I've progressed a little further with my project. The only problem is depending on the number of entries all the data is moved to the bottom of the table. any ideas? Any help would be appreciated?

I've attached the file so you can see.

**Arkadi** · 11-22-2018, 12:05 PM

Did you use "format as table" to fix the colour problem, or conditional formatting?
Format as table gave me the same issue which is why I mentioned the conditional formatting option.

**CPAC** · 11-22-2018, 01:29 PM

Hi, yes I used "format as table". I've now followed the link you provided originally and used conditional formatting - Perfect!

Thanks again for all the help and support with this one.

**Arkadi** · 11-22-2018, 04:32 PM

My pleasure

Still trying to figure out how to make this work with the format as table method.

Code required to order data in a table when a button is clicked

LinkBack

Thread Tools

Rate This Thread

Display

Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Re: Code required to order data in a table when a button is clicked

Thread Information

Users Browsing this Thread

Similar Threads

Code Works only in Debug Mode, Not When Button is Clicked.

[SOLVED] VBA code to show updated data in the listbox after the data is entered and button clicked

Table on the basis of raw data..Code REquired..

[SOLVED] VBA Code to add numbers when a button is clicked

Code for Button to Submit Data to List in Numerical and Chronological Order

Run code whenever any radio button is clicked

[SOLVED] Code needed to test if user clicked a button

Bookmarks

Bookmarks

Posting Permissions