Automatically maintaining sort orders

[scaffdog845]

Group,

Is it possible to set up a workbook to maintain a certain sort order for each time a new entry is made? The book in question has a data entry sheet1 with 4 rows. 1:1 is date in ascending order while 2:4 have numbers that will be in no particular order. 3d refernencing is being used on sheets2:sheets4 to copy the data from sheet1. The intention is to input data into sheet1 by date while maintaing a sort order on sheet2,3 and 4 ascending order without manually resorting.

[JBeaucaire]

Post up a sample workbook showing your data, your entry method, and the RESULTS you're looking for. What triggers the sort? Make sure the whole process you want to follow is represented in your sample workbook, even if it requires multiple sample sheets.