Programmatically Sorte Rows that are Arranged in Subgroups.

G

Guest

Would like to write a macro that will allow me to sort a group of rows
without knowing how many rows are in the range. The number of rows change
each day I have to sort the sheet.

Each time I have to sort a spreadsheet named “Warehouseâ€, I have to select
the rows that contain the information about a specific warehouse in my
company. The information comes to me already grouped by warehouse number, but
the number of rows containing information about any specific warehouse
changes each day.

The warehouse groups are arranged in ascending order and each group is
separated by a “Total†row.

Here is how the sheet looks like:

Wrhs# Invice# $Sold $Purchasd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting rows out of order after all rows are numbered in sequence 1
VBA - loop that arranges rows 1
Find Specific Rows in Range and Create New Tab 18
Macro to hide rows? 1
Count rows, post result in new book 7
transferring data in rows of one table to columns of another table 1
How to filter rows data based on background color of individual cells 1
Macro to automatically hide rows based on 3 cells 2

Top