Copying rows from other sheets, and sort them based on a priority column

**BKevinT** · 03-25-2010, 08:59 AM

Hi,

I have a question I hope you can help me with.

Attached is an Excel doc example of what I'm trying to do. The document I'm working on is obviously a lot bigger, with many more sheets etc.

In the two sheets Source sheet 1 / Source sheet 2; I have a column (Priority) containg a numerical value 1, 2, 3, 4 or 5 for each row.

In the sheet called Sorted Result, I want all the rows from the source sheets with a priority number sorted.
I'm not too good at explaining things, so it's probably a lot easier to take a look at the example file, where I have created the Sorted Result sheet the way I want it to be

Thanks in advance...

**ajaykgarg** · 03-25-2010, 09:08 AM

It will take multiple steps.

1. Write code to copy all data from source sheet 1 to sorted results sheet.

2 Write code to copy all data from source sheet 2, identify last used row on sorted results sheet, and paste this data after the last used row.

3. Write code to sort data using code similar to following on sorted results sheet:-

Please Login or Register  to view this content.

hth
Ajay

**JBeaucaire** · 03-25-2010, 11:07 AM

1) Right-click on the sheet tab where you want this consolidation occur.
2) Select View Code
3) Paste in the sheet-event macro into the sheet module that appears:

Please Login or Register  to view this content.

4) Close the editor and save your workbook as a macro-enabled workbook (???.xlsm)
5) Now switch to a different sheet, then back to that sheet...the list will reassert itself each time