Michele Ferrao
New Member
- Joined
- Sep 9, 2014
- Messages
- 3
Hello
I would really appreciate your help in understanding how to automatically sort rows depending on the value in a certain column.
The data in the table is based on a Vlookup formula. The range of data including the headings is from B9 to K24. I want to sort the information in these cells depending on column C(Product Code) with values from C10 to C24 in a descending order automatically. Row 9 is the heading of the table.
<tbody>
</tbody>I have tried the VBA’s codes provided in previous posts, but cannot amend it to suit my needs. Your help will be really appreciated.
I would really appreciate your help in understanding how to automatically sort rows depending on the value in a certain column.
The data in the table is based on a Vlookup formula. The range of data including the headings is from B9 to K24. I want to sort the information in these cells depending on column C(Product Code) with values from C10 to C24 in a descending order automatically. Row 9 is the heading of the table.
Component Ingredients | Product Code | Weight Kg/L | % | Allergen, if present | |||||
Roast beef | 35 | 0.100 | 28.33% | nil | |||||
Rock melon | #N/A | 0.070 | 19.83% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Whole grain mustard | #N/A | 0.040 | 11.33% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Melon | #N/A | 0.070 | 19.83% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Tomato Wedge | #N/A | 0.026 | 7.37% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Parmesan | #N/A | 0.020 | 5.67% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Pesto | 5 | 0.010 | 2.83% | nil | |||||
Diced tomato | #N/A | 0.005 | 1.42% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Arugula | #N/A | 0.005 | 1.42% | ||||||
Sundried tomato | #N/A | 0.004 | 1.13% | ||||||
Lolorosso | #N/A | 0.002 | 0.57% | ||||||
Kalamata olive | #N/A | 0.001 | 0.28% | ||||||
Chive | #N/A | 0.001 | 0.28% | ||||||
Wheat bread | 400206 | 1 slice | #VALUE! | ||||||
#N/A | 0.000 | 0.00% |
<tbody>
</tbody>