PDA

View Full Version : Importing a defined range from another sheet and then grouping/Sorting



ads_3131
12-05-2011, 05:25 AM
Hello all again....

I need help with some VBA for a button on my spreadsheet, im wanting to pull data from a set range on another sheet(2) (A5:D5), then paste on sheet1 (B5:E5)........ then at the same time sort/group the cells/rows which have a common cell, for example by number, then all the rows which have 1 in column B (sheet1) are grouped .... and so on for every cell in that range being imported....

Any help would be great!

Tar :)

Bob Phillips
12-05-2011, 05:56 AM
Do all that stuff with the macro recorder, job solved.

ads_3131
12-05-2011, 06:51 AM
But the data will be random each time.... and How would i group everything within column B that is similar e.g all the 1s together, all the 7s together etc ?