I have a spreadsheet that I need to have the states grouped under what division it would fall under.
Ex. Column C has what state that data came from... I need to take all that data in that row to the division that state belongs to. If all 50 states are present I need them to be grouped with what division that state belongs to. All the data in that row needs to follow. Then I need to subtotal each division.
I would like to have a macro in place as I will need to do this every week. The categories in the columns will always be the same but the data will be different weekly.
Any help / direction would be highly appreciated!!!!!!
Hello rawicker5,
Welcome to the Forum!
If you post a sample workbook that would be a good start.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks