auto-sort

The pay of an employee in applicable level in the Pay Matrix will be fixed by multiplying the existing basic pay by a factor of 2.57, rounded off to the nearest rupee and the figure so arrived at will be located in that level in the Pay Matrix and if such an identical figure corresponds to any...

I have a group of cells (A2:C20) that constantly has new information. I always have to go into the data/range and sort the values so that they are in order by date. Since the content of this group of cells is always changing, it is kind of annoying to have to re-sort the list all the time. Is...

Hi all, I have data in the following form: <tbody> Region Value Volume North 734198 3409 South 429837 8374 East 384209 1024 West 636412 3412 </tbody> The data in this sheet is derived using a sumif() and countif() function on a separate sheet, and I'm trying to create a macro to...

Howdy! I am definitetly a novice at VBA and I am hoping someone with more VBA skills than myself can spot the error below. I keep getting a "Compile Error: Expected End With" error. This code is supposed to auto sort data in a few columns as information gets added. Here is the code: Private...

Howdy! Ive seen elsewhere on the forum, notably here and here, that show what I want to do but for the life of me I cant adjust the code to get it work correctly. I have 6 total sheets (Sheet2 through Sheet 7) that have the same column headers and data on each sheet (A6:J). I want to copy this...

Howdy! I am trying to have a sheet auto-sort the data in it. Ive been successful in that it auto-sorts the data however, Ive been unsuccessful in that when I run the macro it puts all the blanks at the top. Can someone help me adjust the below formula to ignore blanks? Thanks! Below is what I...

Hi everyone! I've been trying to figure out how to autosort a file for work, but I can't quite figure it out... Basically, what I have is a worksheet with 21 columns and 15,000 rows. The first column contains the product code and the third contains the product name - for this sorting, these are...