Sub CopytheRowoftheActiveCell()
With Worksheets("Master")
selection.EntireRow.copy Destination:=
.Cells(rows.count,1).End(xlup)(2)
..Range("A1").CurrentRegion.Sort Key1:=.Range("B1"), _
Header:=xlYes
End With
End With

Click in your cell or Cells/rows with the new data and run the macro.

--
Regards,
Tom Ogilvy


"Spreadsheet" wrote:


I've asked this question elsewhere with no responses. I have several
worksheets, each containing data pertaining to a subset of a
population. I also have a master sheet which contains all of the data
from all of the subset sheets. Thus, this master sheet contains data
pertaining to the entire population. THe master sheet is sorted.
Currently whenever I add new data to one of the subset sheets, I
manually copy this information onto the master sheet and then resort
the master sheet. This is very tedious. How can I cause the master
sheet to automatically update and resort every time I add new data to
one of the subset sheets? Any help would be greatly appreciated.
Thanks.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=551134