vba sort

so with the blanks (empty rows) conundrum solved, moving on to the next area so, here is the working copy of the vba code from post 67 Sub copyto_test_REMOVEBLANKS_b18() 'working (by Shina67) Dim sourceWS As Worksheet Dim destinationWS As Worksheet Dim sourceRange As Range Dim...

Hi, Like the title says, I'm trying to make a VBA to sort "all" my data based on D column(descend). I need a VBA that works on the active sheet regardless of name(always different). Also, the number of columns and rows changes every time I run the report, so I cannot have a specific range...

i need a command action button to sort a table called table1 based on column ”No. Date” from Z to A. it’s important to note that my table increases everyday so the range must not be limited to a certain limit

Can someone help me sort sheets according to Transaction Type (Column N) using one VBA code that applies to all worksheets, which have variable number of rows? In ascending order and has fixed column up to CV. PS. Newbie in VBA but willing to learn.

Hi! I am a mostly-self-taught VBA novice. I am trying to create a VBA formula that will go through my previously sorted data and count only the visible cells with a date within two years of the current date. So far, here is where I am stuck: Sub CountIF() ' ' CountIF Macro ' With...