Sorting

[thegemba]

I am new to the Forum and if possible can help someone help me with a question. I have a master spreadsheet that I sort column "A" for payroll. I would like to make a copy of that same spreadsheet and have it sort for Column "B". I have no problem populating the second spreadsheet from the master. My question is as I enter data on the master can I get the second (copy) spreadsheet to sort column "B" automatically (A to Z) without having to go up and highlight and hit the sort button??? Thanks in advance.

[Royzer]

If you put this formula in Sheet2, B5 (for example), then copy it down as many rows as you need, it should automatically sort the data that is pulled over from column B of Sheet1 as you enter it into Sheet1.

=SMALL(Sheet1!$B$5:$B$100,ROW(B5))

Change the row number in the ROW() part above to match the row number you are going to paste it into on sheet2. Paste it, then copy it down as many rows as necessary.