Articles

How to create a macro to sort data to new tabs in excel

December 5, 2012 at 05:38:23
Specs: Windows 7

I am trying to recreate a macro I had on my old computer (written by someone I used to work with). The macro was made to run on a large excel spreadsheet (a lot of data) and copied all rows with the same value in a certain column and put them in a new tab (and named the tab whatever the value in that column was). Then it applied a subtotal function on each tab (same for each tab) and did some other formatting (same header row for all tabs, hides certain columns on each tab). The original tab retained all of the information, but was subtotaled and formatted the same as the other tabs (although, that isn't crucial). Please help!

See More: How to create a macro to sort data to new tabs in excel

Report •


#1
December 5, 2012 at 10:01:20

If you can post a short example of your data, noting which column has the values to be sorted on, perhaps we can help.

Please click on the following line and read the instructions found via that link before posting your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question